Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing CSV
Message
 
 
To
16/03/2009 12:04:53
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01388402
Message ID:
01388416
Views:
53
>The original file that I download from the company's web site is a csv file. If I open the csv with Excel, and then SAVE IT as a csv out of Excel, THEN import it into VFP, it parses correctly.
>
>Will the code that you posted in this response avoid (or make invisible) that intermediate step so that instead of going:
>
>csv ->excel ->csv ->VFP
>
>it will go:
>
>csv ->your code ->VFP ?
>
>C

Actually, my code was for saving from Excel. In other words, you can simplify your task by just loading file into Excel, saving as Excel and then try type XLS instead of CSV (my code would not be needed).
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform