Importing an huge ASCII delimited text file into MS Access 2003

S

Seawimp

How can you Import an ASCII delimited file larger than 2,000,000 kb into MS
Access 2003? The Import function Errors out.
 
C

Chris O'C via AccessMonster.com

Sorry, you can't. Access 2000 thru 2007 hold up to 2GB total, but that
includes system tables, data pages, etc. Your data file won't fit.

You can install SQL Server Express, which holds up to 4GB of data (besides
logs, system tables, etc). Link to a table in SQL Server Express from Access
2003 with an ODBC connection. Import into Access with the import text wizard
using that linked table.

Chris
 
Top