Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Modifying Excel Import Procedure?
Message
From
11/04/2002 11:34:07
N. Lea
Nic Cross Enterprises
Valencia, California, United States
 
 
To
11/04/2002 11:24:52
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
00643706
Message ID:
00643782
Views:
13
Thanks for the assistance with all this stuff. Unfortunately, it does not seem to be taking to Office XP too well. It cannot find the variable xlDBF3.I am assuming that is what it is supposed to convert it to.

>Download #9498 contains Excel constants. You need it for the following program.
>
>The result will be exactly the same as if you export manually from Excel. For best results, the spreadsheet should have a first row with column (field) names.
>
>
>#include include\xl97cons.h
>oExcel = CreateObject("Excel.Application")
>oExcel.Visible = 1   && for debugging
>oExcel.Workbooks.Open(fullpath("") + "sample.xls")
>erase sample.dbf
>oExcel.ActiveWorkbook.SaveAs(fullpath("") + "sample.dbf", xlDBF3)
>oExcel.Activeworkbook.Close(0)
>
>
>See also: SET CPDIALOG.
>
>HTH, Hilmar.
>
>>I attempted to export directly from Excel, but it cut off a lot of the data. i looked up the automation, but I do not understand it's process. I am attemping to create the table first and append from, but it will not let me append from an xls file.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform