Posted - 09/02/2006 : 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 of
varchartype(8000) and then using cursor,to seperate field
and load it into another table.
Edited by - getsaby on 09/05/2006 17:35:20