Recent content by lhomme

I have a set of multiple CSV tables linked to an Access database. (There are dozens of almost 2GB sized files.) Is there a way to run a query on all of them (or sets of them) as one gigantic table?

That may be a bug then, because imputing "2" or "3" results in lots of small files. (~200MB and ~140MB) respectively.

RuralGuy: I am aware of the difference between Importing and Linking tables. The "Bad File Name or Number" is what I get when trying either. Do you recognize the error? DCrake: Thanks for the file. Unfortunately, I cannot get it to split a test 4GB file into anything larger than 200MB chunks...

Hi, I have a similar problem: I have a massive data dump split into 12 CSV files, 11 of which are over 4GB in size (>100M rows total). I cannot access the source data or request another data dump. I have Access 2003 & 2007 available. I also have Excel 2003 & 2007. I am running XP. When I try...