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-10-28 : 07:55:29
|
| rachel writes "I am trying to import a text file to sql server. In the DTS Import/Export Wizard, I see the column fileds are spreaded into more than one lines. I cannot use the fixed field option to separate the column. Is there any way I can do it?" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-28 : 13:01:54
|
| Show us an example row of your text file.Tara |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-29 : 08:58:28
|
| Sounds like the data in one of the columns contains line breaks. You'll need to use another row delimiter (something different to CarriageReturn + LineFeed), or replce the line breaks within the data before it is exported, or use a different format (like Excel, or XML)Kristen |
|
|
|
|
|
|
import text file to sql table