LINK DATA MORE THAN 2GB

[szhang1988]

Hi, I have a fixed width flat file close to 3gb. I need to import the data into Access database 2003. I know Access db has 2gb limitation, so i tried to link to this file and extract partial data into an Access db, but i got an error message "xxx.txt contains no data." I guess this could be caused by the 2gb limitation, anyway to work around this? thanks much in advance

 

[JerryKlmns]

Since it is a fixed width file, compute the amount of data for one record only. Open the file and read the amount of records that do not exceed 1 GB and write them to another file with the same format. Keep on until the big f(l)at file is chopped to chunks. Import all these files to different mdbs and link these tables to an mdb file or link the txts created to one mdb file.
The other option would be a real RDBMS like SQL server, Oracle etc...

Unless you could manipulate all the data (during import:read line, chop it to fields for tables etc ) for that file for a well-normalized mdb