SQL server bulk insert for multiple csv files from a single folder. I want store each file as each table at a time I want insert 10 csv and txt files on SQL server. Please provide me any SQL script.

Question

SQL server bulk insert for multiple csv files from a single folder. I want store each file as each table at a time I want insert 10 csv and txt files on SQL server. Please provide me any SQL script.

Answer 1

BULK INSERT tbl1 FROM 'C:\temp\file1.csv' WITH (FORMAT='CSV')
BULK INSERT tbl2 FROM 'C:\temp\file2.csv' WITH (FORMAT='CSV')
...
BULK INSERT tbl10 FROM 'C:\temp\file10.csv' WITH (FORMAT='CSV')

That is, you need to create the tables before hand. And if you know tell us that you don't know the structure of the files beforehand and can't do that, I am afraid that the answer is that you cannot do this in SQL Server alone, but you need to employ an external tools like SSIS, SQL Server Integration Services.

Answer 2

Hi @nn

Have you validated all the answers on your previous post: SQL query to import multiple csv/txt files into SQL Server?

As I answered, you might need a dynamic query if you do not want to create table or bulk insert files one by one.

I want store each file as each table at a time I want insert 10 csv and txt files on SQL server. Please provide me any SQL script.

Have you made any attempts on this issue? Or you have any problems writing the script, if so, please describe the script you wrote and the specific issue.

Best regards,

Cosmog

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".