SQL query to import multiple csv/txt files into SQL Server.

Question

SQL query to import multiple csv/txt files into SQL Server.

nn 20

2 answers

Your answer

Answer 1

Olaf Helper 47,581

You will need one query per different file sturcture.

See

https://learn.microsoft.com/en-us/sql/t-sql/functions/openrowset-transact-sql?view=sql-server-ver16

for how to.

Erland Sommarskog 128.7K Reputation points MVP Volunteer Moderator

2024-07-23T09:50:48.2466667+00:00

And even if all files have the same structure, you need to import them one at a time. I guess this is one of the reason SSIS exists, so that you can easier orchestrate this. Do it from SQL Server only? Yes, it is possible, but it is quite bit of kludge. Nothing to recommend.

Answer 2

Hi @nn

To import multiple csv/txt files into SQL Server using SQL query, you typically need two steps:

First, you need to list all files inside a folder to a table.

Then generate dynamic bulk insert query to import these files.

It is suggested to use SSIS to accomplish this, see this blog: SSIS - How To Load Multiple Files ( .txt or .csv ) To a Table With File Names.

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".

Share via

SQL query to import multiple csv/txt files into SQL Server.

2 answers

Your answer