| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I merge multiple csv files in one Excel file? | Excel Worksheet Functions | |||
| merge multiple worksheets from multiple excel files into oneworksheet | Excel Discussion (Misc queries) | |||
| How do I merge multiple xls files into one file? | Excel Discussion (Misc queries) | |||
| How do I merge multiple xls files into one file? | Excel Discussion (Misc queries) | |||
| How can I merge multiple sheets from different Excel files workbo. | Excel Worksheet Functions | |||
Linear Mode
