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 |
getsaby
Starting Member
11 Posts |
Posted - 2006-09-02 : 15:41:32
|
I have this EXCEL file, with lot of records,some of the records are empty i.e having no values in it.The excel file is TAB delimited, so for No record value, it insert TAB and each records also is seperated by a TAB field to.So when I load this data into table, The empty row gets filled up with the record which is right to it. There is a left shift..Below is the code..........I load data from the EXCEL file into this BIG field which is ofvarchartype(8000) and then using cursor,to seperate fieldand load it into another table. |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-04 : 06:03:47
|
Heard of BCP or OPENROWSET?Peter LarssonHelsingborg, Sweden |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-09-05 : 20:47:07
|
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926MadhivananFailing to plan is Planning to fail |
|
|
|
|
|