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 |
|
bridge
Yak Posting Veteran
93 Posts |
 Posted - 2005-09-30 : 08:37:21
|
| How can we properly export and import data (Table->File->Table) using BCP and BULK INSERT when tables contain TEXT columns? I ham having problem in exporting and importing. While DTS Package does this correctly. But I have to do it with 50+ tables so I want to do this using BCP and BULK INSERT. Please help me out |
|
|
juvethski
Starting Member
46 Posts |
Posted - 2005-09-30 : 10:45:50
|
| bcp is a bit tricky. you have to consider unc if you want to use your own file paths. otherwise it defaults to the server's c: drive. you should be able to do what you want by using the 'exec' command. build a sql statement and store it a variable, (eg @sql), then do a 'exec @sql' statement. you can also import/export excel files. i just did it yesterday, thanks to this forum. it helped me a lot! |
 |
|
|
bridge
Yak Posting Veteran
93 Posts |
Posted - 2005-10-03 : 03:04:54
|
| Yes I have also done this successfully but I have problem when the table contains TEXT field. Please help me in find way for exporting and importing data using BCP and BULK INSERT when there is a TEXT field in the table. if anybody knows please do help me. |
|
|
|
juvethski
Starting Member
46 Posts |
Posted - 2005-10-03 : 10:40:44
|
| yes we have the same problem. i've asked the same question in the other post but so far no one has responded. pls let me know if you found out the solution. thanks. |
|
|
|
|
|
|
Import/Export using BCP and Bulk Insert