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 - 2001-02-13 : 17:52:20
|
Todd writes "I have a legacy application that is exporting out some TAB delimited data which I am using DTS to pick up and put into a table. The problem is that some of the columns have multiple values! So I am ending up with a Table that violates the First Normal Form due to repeating data. The delimter for the multi-valued data is an asteric or tilda.
I would like to import the first data set and then go through the columns with repeating values and put them into another Table.
I have read through 2 books and BOL and found no examples of this type.
Any advice would be appreciated.
Thanks.
Todd" |
|
|
|
|
|
Importing Data with Delimters & Multi-Values