I need to do a data import from an excel to sql server.
My big problem is that the data coming from the source of an excel column is being interpreted by this wizard as varchar, even though I make all the changes that I can imagine.
Basically I've tried:
- Do not excel change the data type (put as currency) (put as general)
- Do not excel, copy data, put in text file, change type of data then paste into excel. (put as currency) (put as general)
In both ways the wizard interprets that it is of type varchar
How to change this?