Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-28 : 06:55:52
|
| Kajori writes "I am using the INSERT BULK command to import data from text file into a specific table. The text file is being chosen by the user at run-time. The process is working only when the text file is located on the SQL server.How do I do this when the file is stored on other network or local machine(other than the server)?I am using SQL server 7.0 with win 98 machine as the client and win NT 4.0 (small business server)as server." |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-08-28 : 12:04:15
|
| Have you tried using UNC naming? (e.g. //machinename/sharename/path/filename.txt) |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-08-28 : 14:50:44
|
| What account is your SQL Service running under. If its Local System then SQL has no network access - if its a domain account, make sure it has appropriate permissions to the network shareHTHJasper Smith |
|
|
|
krayz
Starting Member
1 Post |
Posted - 2002-08-29 : 08:29:44
|
quote:
Have you tried using UNC naming? (e.g. //machinename/sharename/path/filename.txt) Yes I have.There's no problem if the text file is located on the server but the problem starts when it is in any other network machine or in the local machine.There's also no problem if the server's drive is mapped on the local machine.
|
|
|
|
|
|
|
Importing text file data