load database from text file

Question

say I have a table named XY_values with columns X_values and Y_values.

now, I have a text file xy.txt which contains those x values and y values, with x values in the 1st column and y values in the second column.

is there any SQL command to load those x and y values from the text file into the XY_values table in the database?

thanks.

Answer 1

Microsoft SQL Server has an import facility which can read text files and import them as tables, or even send them off to another datasource. In fact, I remember quite a few managers buying SQL 7 on the strength of that functionality.

Answer 2

I would look into using SQL Server Integration Services (SSIS) to do this. Here is a good link that goes over importing data from a text file using SSIS.