Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is CSV the best format to import data?
Message
From
24/08/2017 11:47:33
 
 
To
24/08/2017 09:40:12
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01653669
Message ID:
01653678
Views:
54
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform