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 |
|
davebatt
Starting Member
17 Posts |
 Posted - 2009-07-03 : 06:57:51
|
| Hi I have a query about importing from excel. I have a field with an address on multiple lines, how would I import this and have each line appearing in a seperate field in my sql server table?12 My streetSomewhereSomeplaceAAA 123addLine1 | addLine2 | addLine3 | postcode| Thanks in advance |
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2009-07-03 : 07:40:27
|
| Do you always have 4 Address lines for each record? http://www.sqlserver007.com |
 |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-07-03 : 09:20:24
|
| HiIn SSIS using pivot, unpivot so u can able to transpose the columns into rows and rows into columns. so u can maintain col add1, col add2.... |
|
|
|
|
|
|
Importing a multi line excel cell into seperate fi