Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CSV to SQL server - best way?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00886406
Message ID:
00886429
Views:
22
Michael,

BCP installs as part of QueryAnalyser.. C:\Program Files\Microsoft SQL Server\80\Tools\Binn\bcp.exe

You can at the least build a batch file to invoke the BCP, but then it runs on the client machine.

You should be able to run it from the server as well.

This is something that you'd need to get their DBAs involved in the process.

>Thanks for the response. Is BCP something that has to be run from the SQL admin console, or can I somehow send it a file from a client application...?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform