0

I'm very new to MS SQL, and I ran into this problem: Cannot bulk load. The file "c:\data.txt" does not exist

I am trying to give co-workers a custom query with variable input (they will use different input.txt daily). I understand that for Bulk Insert to work, the input file needs to be on the server.

There seem to be a couple of solutions: MS SQL Server - Bulk Insert Across a Network

What would be the best way to upload a local file progmatically?

Community
  • 1
  • 1
PoorBob
  • 413
  • 4
  • 16
  • is there a common network share that they can all use? i.e. \\server\allusers\data.txt that everyone calling this bulk copy has access to? – Kevin Cook Mar 12 '15 at 17:24
  • Most of our employees only use the server through an MS Access UI, and we have FTP connections set up. – PoorBob Mar 12 '15 at 18:35
  • I'm making a folder that we can all share and access natively. Did you have an idea for something like that specifically? – PoorBob Mar 12 '15 at 21:18

0 Answers0