Thanks for the quick reply. Unfortunately, the resulting table exceeds 2GB. Access won't complete the operation. Unless maybe there's a copying method I'm not familiar with.
In Access 2021 on Windows 10, I have linked a 1.9GB text file (28 million records, 3 fields). I need only a subset of those records. Unfortunately, attempts to query the table to produce that subset result in an error:
The query cannot be completed. Either the size of the query result is larger...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.