Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is CSV the best format to import data?
Message
 
 
À
24/08/2017 11:47:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01653669
Message ID:
01653685
Vues:
55
Thank you.

>Nope. Best way is the sdf format vfp itself offers/uses only with "copy to" but not with export comand.
>Not only my opinion, but most large adress sellers we worked with prefer that format. Downside is the extra text file describing data layout and field length, which always has to be knwon for import, but is easy to write out
>
>>I will be discussing (later this morning) with a company who is supposed to export the data from their SQL Server database with the goal that I will import it in my SQL Server database. Initially the agreement was that they will provide me with the CSV format files. My questions is, is this "the best" or "sufficient" that I can then import the data into my database? Or should I ask for another format? (the SQL Server backup is out of the question because their SQL Server database has their other customers' data).
>>TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform