View Single Post

   
  #1 (permalink)  
Old 02-27-2008, 08:10 PM
=?Utf-8?B?YmFsYQ==?=
 
Posts: n/a
Default Row of data interchaged automatically when import from MS xl 2003

Hi all,

I import MS Excel 2003 spread sheet in MS SQL Server 2000 through MS SQL
Server 2000 Enterprise Manager. In excel two sheets (sheet1 and sheet2) of
data is there. I imported first sheet data in first time in relevant table of
database and done second sheet of data in next time. My excel file have 2000
rows and 100 columns of data. All the data are imported in relevant
attributes cells in good manner. But the first 16 rows are sorted
automatically. I am trying to say that first row data is match with my excel
file. But second row data have gone to 7th row and 7th row have gone to 5th
row like that. Except that 16 rows all other data are matched with my MS
Excel 2003 file. I need the data sequence what I have in my excel file. What
is the problem occurred? How can I solve this?
Actually the problem occurred in first some rows so I found the mistake. If
it comes after 1000 rows how can I predict and rectify?
Please help me. I don't have more knowledge in MS SQL Server 2000.
Thanks,

With Regards,
bala.
Reply With Quote