How can I merge multiple files using SQL?

  • Thread starter Thread starter mb
  • Start date Start date
M

mb

Hi there,

I try to merge a few dozens of .csv files into one worksheet. This works
well with a query like:
SELECT * from file1 UNION SELECT * from file2 ...
However, the querytable.command does not seem to accept more then 40 files
(may be path-length dependent).

Is there some other SQL method to merge files. I also tried the "SELECT
INTO" command but that only resulted errors.

Any ideas?

Best Regards,
Marc
 
Wow, a query with 39 UNIONs seems like a lot to me! Perhaps it's a
limit for the data provider. Anyhow, as a workaround, can you use more
than one querytable?
 
Back
Top