format cell type problem

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data type issue in excel sheets 1
Excel does not accept text format! 0
Problem with MS Word paragraph and character styles: format getting messed up 2
Make long strings visible? 7
conditional format - table - cell empty return default color 1
Forcing Excel to Import .CSV data 2
Change cell type 3
Data type issues adding data from vbscript 7

Top