whitesox99
MIS
Hi,
How can I read a file placed in a shared folder on a network from MS SQL Server Stored Procedure.
Thanks.
How can I read a file placed in a shared folder on a network from MS SQL Server Stored Procedure.
Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
File Access on Network from MS SQL Server SP
- Thread starter whitesox99
- Start date
- Status
mrdenny
Programmer
- May 27, 2002
- 11,595
Look up the bulk insert command in Books Online. It allows you to import files from local folders or network shares.
The catch is that your SQL Server must be running under a domain account and the account that the SQL Server is running under must have access to the folder and file you wish to import.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
The catch is that your SQL Server must be running under a domain account and the account that the SQL Server is running under must have access to the folder and file you wish to import.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
