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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
Import ASCII Char 31 delimited file 0
Import Text file with Pipe Delimited - 2007 4
Trouble importing foreign language accents into Access 2003 11
Odd character display (ASCII 128-159) 1
Import errors importing Text into existing table, header vs no hea 3
Losing long numbers regardless of format 2
Importing Excel Data Into MS Access Memo Field 1

Top