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 |
|
MarkWinslow
Starting Member
2 Posts |
 Posted - 2002-04-05 : 11:13:41
|
| I want to import a whole edi text file into a column using bulk insert. I see that the command will insert into a table line by line. Is it possible to insert the whole file into a column? |
|
|
MarkWinslow
Starting Member
2 Posts |
Posted - 2002-04-05 : 11:16:59
|
| Or is there a better way to do it? |
 |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-04-05 : 11:30:17
|
quote:
I want to import a whole edi text file into a column using bulk insert. I see that the command will insert into a table line by line. Is it possible to insert the whole file into a column?
There's no difference. Unless you mean you have an existing table with existing rows and you wish SQL Server to magically divine which rows in your text file should go with which rows in the table ...setBasedIsTheTruepath<O> |
|
|
|
Jay99
468 Posts |
Posted - 2002-04-05 : 11:34:36
|
| set the column delim = 'somestringthatwillneveroccur'.Jay<O> |
|
|
|
dsdeming
479 Posts |
Posted - 2002-04-05 : 12:46:10
|
| If you're trying to BULK INSERT the edi file into a table with a single column so you can slice and dice it yourself, make sure the column is at least as wide as the widest row in the edi file. It should BULK INSERT straight in. |
|
|
|
|
|
|
Import text file using Bulk insert