Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating table from CSV
Message
 
 
To
05/11/2016 15:28:41
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01642781
Message ID:
01642784
Views:
57
>I need to create a table from a CSV (which comes from PayPal, Bank, etc.).
>
>Just a WAG but what if you open the CSV in Excel and save it in .XLS (Office 97 - 2003 format)? You can easily import an XLS into VFP - you can even use automation to open the .CSV in Excel and save it in the proper format before importing into a DBF...

Good idea, but I have no idea if they actually have Excel on their computer.

What I am trying to do is get the first row in the table so that I can then create a table from that with the correct column names of the CSV.

I notice that if I use :

APPEND FROM PayPalDownload.csv TYPE DELIMITED WITH ","

it does give me the name of the fields in the first record - which I can clean up if needed to get rid of the apostrophe(s) for each field.. When I save the file as a office 2003 it is cleaner and the first row would not have to be cleaned up. However, like I said I have no way of knowing if they have Excel.
Previous
Reply
Map
View

Click here to load this message in the networking platform