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-12-13 : 09:46:36
|
Steve writes "OS: Windows NT4 SP4SQL: 6.5 SP5Is there any way I can automatically import data with a varying number of columns per row into a SQL 6.5 table Input ^ delimited data files....1^a^b^c^d^e^f2^a^b^c^3^a^b^c^dResults required...Id Col1 Col2 Col3 Col4 Col5 Col61 a b c d e f 2 a b c null null null3 a b c d null null i.e. row one may have 7 columns and row two may have 4. Can BCP(?) 'pad' out the missing 3 columns in row one with null values so it can be imported with a format file?Steve." |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
|
|
|
|
|
Conditional importing using BCP with SQL version 6.5 