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 |
|
rajani
Constraint Violating Yak Guru
367 Posts |
 Posted - 2006-10-11 : 16:09:44
|
| Hi friendsin our front end app (c#) we've utility to import and export data from/to different users.when exporting ,what we do is just create ".sql" file with "insert " statements we need. all works fine.out issue is,when importing users must import it from server(where sql server is) bcoz as we know by default it looks at local folders.so users cant import from their local workstations.am just wondering how you normally handle such scenarios ?Thanks for ur help.Cheers |
|
|
rajani
Constraint Violating Yak Guru
367 Posts |
Posted - 2006-10-12 : 22:07:41
|
| btw my sql stmt is something like belowINSERT INTO REGION (ID, REGION, DATA) SELECT 2 AS ID, 'North America' AS REGION, * FROM OPENROWSET( BULK 'C:\DATA\NorthAmerica.TXT',SINGLE_CLOB) AS MYTABLEGOCheers |
 |
|
|
|
|
|
import from a file