Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel file Save as .DBF
Message
 
To
02/10/2006 12:46:04
Kay Alexander
Pennsylvania Farm Bureau
Pennsylvania, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Novell 6.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01158600
Message ID:
01158603
Views:
20
>Hi,
>
>After opening the excel spredsheet with "oWorkbook=Getobject('c:\my documents\sample.xls')". Then, I am trying to save the file as DBF with "oWorkbook.SaveAs('c:\mydocuments\sample.dbf',...)" but I am not successful. I am referencing the book "Microsoft Office Automation with Visual FoxPro", and it describes, I need to use the file format as an optional second parameter with command "...SaveAs...". I tried many different possible ways for the second parameter, but none had worked.
>
>Thank you in advance.
>
>Kay
#define xlDBF3 8
oWorkbook.SaveAs('c:\mydocuments\sample.dbf',xlDBF3)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform