0
I need to import data from an excel to sql server.
My big problem is that the data coming from the source, from an excel column is being interpreted by this Wizard as varchar, even though I make all the changes I can imagine.
Basically I tried:
- In excel change the data type (put as currency)(put as general)
- In excel, copy data, put into text file, change type paste into excel. (put as currency)(put as general)
In both ways Wizard interprets that he is the varchar type
How to change that?
Is it possible that a data is in an incorrect format? A
alternativasolution: Import the data into a time table, then make an Insert with select in the correct table, correcting the types(if there is a wrong data goes from the error in the conversion and you will identify)– Caique Romero
It’s not, the spreadsheet is right
– gabrielfalieri
But good idea, thanks
– gabrielfalieri