The Microsoft Jet database engine will only support Excel files that are under 255 columns wide, 4 gb file limit. These maximums are the same for Access and text files. If you load this data into a more robust database like MySQL, MS SQL, Firebird, etc, you will have far more flexibility with larger tables.
Hope this helps!
Hi Tracy -
I am joining together csv's with a union. All of the csv's are under the sizes you listed however when I join them together I get the error. Is there a workaround for this without having to use a database?
HI, Matthew. As a way to identify the source of the error and work through the problem, I'd change the process to use a text file as the data source. After you get the process to work using the text file, then try to make it work with the your Excel and/or Access sources.
Here s recent thread that will help you be productive in exploring the text file as a data source:
Also, if you do decide to experiment with text files as the data source, I suggest using tab delimited during the export from Excel and/or Access.