Data type issue in excel sheets

[Gurmukh]

Hi,

I'm looking forward to valuable suggestions from experts,we are trying
to port data from excel sheets to SQL Server2000,all the data gets
transferred except one column.During import, the data type for that
column shows as double BUT ACTUALLY THAT COLUMN HAS TEXT DATA.we tried
changing that type to text/general it shows in excel as changed but
while import shows type as DOUBLE.we are not able to make out where
its type is set as double and even if that is the case how it accepts
text data in that particular column??

Can anyone please enlighten us on this problem??we hav ego tstuck with
this?

thanks
regards
Gurmukh Sidhu

 

[Ed Ferrero]

Hi Gurmukh,

Excel is not good at this. You can try to insert one or more dummy rows in
the Excel worksheet that contain data of the correct type.
Then delete the dummy rows with a procedure in SQL Server.

Or, save the excel sheet as a csv file. Then you have much better control
over the import.