Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating table from CSV
Message
 
 
À
05/11/2016 15:28:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01642781
Message ID:
01642784
Vues:
59
>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
Fil
Voir

Click here to load this message in the networking platform