SQL Import: importing data into SQL server from csv

0
votes

I have a table already stored in sql server with all the columns and the data type of the columns. I am now trying to import a txt file into sql server. But since all the fields are already in the string format, it is not able to import the data into the server. Is there any way to change the format of the datatype within the txt file to match that of the table within the sql server? The number of columns are 150 to import

1
sql-serverimport

1 Answers

1
votes

You may need to look into creating a SSIS package and adding the data conversion tool to cast/convert the data being imported into the correct datatype.