Hi,
I'm using SQL Server 8, and coming from the school of Oracle, I'm unfortunately an utter noob with SQL Server.
I'm attempting to import a csv file into SQL, like the following:
The SQL table is expecting a float and varchar value for col 1 and 2 respectively. However, the csv import fails because col 1 is being read as "01"; a string.
What's the best way around this? Remember, my SQL Server is very limited!
I'm using SQL Server 8, and coming from the school of Oracle, I'm unfortunately an utter noob with SQL Server.
I'm attempting to import a csv file into SQL, like the following:
Code:
ID Name
---- --------
01 One
02 Two
03 Three
What's the best way around this? Remember, my SQL Server is very limited!