Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IMPORT .XLS to Memo fields in .DBF
Message
 
To
01/12/2003 13:26:38
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00854759
Message ID:
00854763
Views:
19
Try something similar to this:
LcFlSrcXls="c:\book1.xls"
import from (LcFlSrcXls) xls

alter table book1 alter column (field(1)) M

oleapp = CREATEOBJECT("Excel.Application")
OleApp.DisplayAlerts = .f.
=oleapp.Workbooks.Open(LcFlSrcXls)

sele book1
iscan=0
scan
	iscan=iscan+1
	replace (field(1)) with oleapp.ActiveSheet.Range("A"+alltr(str(iscan))).Text
endscan

oleapp.Workbooks.Close
OleApp.Quit
RELEASE oleapp
>How do I handle import of Excel (.XLS) column data to
>.DBF Memo fields. Now when I execute APPEND FROM Type .XLS,
>all fields come into .DBF record field data, except for
>Memo-type fields in .DBF.
>
>How do I get this data from .XLS into .DBF table file?
>
>DBK
Previous
Reply
Map
View

Click here to load this message in the networking platform