Information générale
Catégorie:
Codage, syntaxe et commandes
>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement