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 - 2004-06-24 : 07:30:04
|
| Putsik writes "Good Day!I have read an article here regarding importing of file using SQL. What i want to know is, is it possible to import file from different machines? Meaning the text file is located on the client's machine and there is a separate SQL Server.Hope to hear from you. Thank You" |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-06-24 : 07:57:35
|
| short answer: YESYou naturally need connectivity to the machine, and permissions. The rest is details... there are many ways... For text files, you will ideally want either csv (comma-delimited), or fixed width, but as long as there is a standard delimitier it should be relatively easy.CiaOCiaO*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
|
|
|
Remote File Access