How can I merge multiple files using SQL?
 

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

How can I merge multiple files using SQL?
 

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?

--

"mb" wrote in message ...
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