Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing CSV
Message
 
 
To
16/03/2009 13:54:13
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01388402
Message ID:
01388459
Views:
81
#DEFINE xlCSVMSDOS 24
* Or
#DEFINE xlCSV 6
* or
#DEFINE xlCSVWindows 23
...
loExcel.ActiveWorkbook.SaveAS("c:\setup\tbdata333.csv", xlCSVMSDOS ) 
>OK, so here's what that code looks like:
>
>
>#DEFINE xlCSV 6
>* or
>#DEFINE xlCSVWindows 23
>
>loExcel = CREATEOBJECT("Excel.Application")
>loExcel.Workbooks.Open("c:\setup\tabledatabufflab.csv")
>loExcel.Workbooks.SaveAS("c:\setup\tbdata333.csv",8)  
>loExcel.Workbooks.Close(0) 
>loExcel.Quit
>
>
>I get an OLE error that says 'Unknown Name'. (I tried changing the '8' to '6' or '23' and got the same).....
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform