Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FoxPro and Excel
Message
 
 
To
15/06/2001 10:35:46
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00519913
Message ID:
00519960
Views:
10
>hi mark. thaanks for the replay. i'm trying to get the folloiwng ot happen:
>
>1. user from the filed submits a excel file to a central email account
>2. program shoudl go out and download the xls file from teh email temp directory
>3. save the xls file as a csv and then copy into a dbf
>
>when i attemp to save the xls into a dbf as it is, because of the macros and etc all i get i garbage into the table. when i save it manually to a csv format, it goes into the table w/o a problem. here's what ihave to read the file and save as csv...
>
>oWorkbook = oWkst.Workbooks.Open(m.att_file)
>oWksheet = owkst.Workbooks.ActiveSheet[1]
>oworkbook.saveas('e:\jeff.csv', 6)
>
>what am i missing?

The second parameter for the SaveAs method. The format constant for CSV is 6, DBF3 is 8.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform