Can i load multiple txt files to table at one time

Question

Like titled, I try to use bulk insert, however, it seems does not work.

Suggest please.

Answer 1

Hi @ELEVEN,

Not sure if you mean like this.

First please make sure that the data in your .txt files has the same structure.

You may check this thread step by step.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

it seems does not work.

"Doesn't work" means what in detail; we can't guess that?

load multiple txt files to table at one time

One SQL process can perform one operation like BULK INSERT at one time, it can load source data only one-by-one.