General information
Category:
Coding, syntax & commands
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only