Is there a .txt size import limit?

[Sylphrena]

I have a smallish .txt file that I've imported to test that it works. Once I confirmed things were working I started trying to import the larger .txt files, which are SQL query output delimited .txt files. But I get the message: [Cannot open the database ". It may not be a database your application recognizes, or the file may be corrupt.]

What gives? The smallish one is 18mb, the larger one is 80+mb.

 

[healey21]

Access has a limit of 2gb when it would stop working. Have you tried to compact the database before you try to import. How are you trying to import the file?