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 |
|
Ash1807
Starting Member
10 Posts |
 Posted - 2015-03-09 : 04:42:34
|
| I am trying to import a flat file into an existing SQL table, using the import/export function of the sql server management studioHowever, when browsing to select the flat file, I am only presented with option to select from the local drive (of the SQL server). My file is on one of our network drives.Will I need to copy the file first to the SQL server, before using the import function?Ash Gajjar |
|
|
sunder.bugatha
Yak Posting Veteran
66 Posts |
Posted - 2015-03-09 : 04:53:51
|
| Browse -> Give the network file path in the connection managerHema Sunder |
 |
|
|
Ash1807
Starting Member
10 Posts |
Posted - 2015-03-09 : 04:57:39
|
| Thank you Hema, but where do I access the Connection Manager?I am using the SQL management studio for the Import/ExportAsh Gajjar |
|
|
|
mandm
Posting Yak Master
120 Posts |
Posted - 2015-03-09 : 10:02:49
|
| Instead of pressing the browse button you should be able to manually type in the full network path and filename of the flat file. |
|
|
|
Ash1807
Starting Member
10 Posts |
Posted - 2015-03-10 : 07:23:48
|
Thank you, works fine now!  Ash Gajjar |
|
|
|
mandm
Posting Yak Master
120 Posts |
Posted - 2015-03-10 : 07:30:54
|
| Glad I could help. |
|
|
|
|
|
|
Importing Data