I've read in many of the posts of the possible reasons why I'd get this error.
I've created these auditor databases for several years. I download the data in .txt format and import it into Access for reconciling purposes. I've been able to work through most of the issues that I run into, including different networks and one-drive sync problems because the databases are all over 2GB (once I get the lines to import).
There are over 2M (1.4GB) lines of data. I need to bring in the dates as "short text" because there is no time and the import won't bring it in.
I've tried .html, .csv and .txt each getting the same result.
The number of fields and header data has been the same with no changes, so that shouldn't be the issue.
Any suggestions would be appreciated.
Thank you, in advance
I've created these auditor databases for several years. I download the data in .txt format and import it into Access for reconciling purposes. I've been able to work through most of the issues that I run into, including different networks and one-drive sync problems because the databases are all over 2GB (once I get the lines to import).
There are over 2M (1.4GB) lines of data. I need to bring in the dates as "short text" because there is no time and the import won't bring it in.
I've tried .html, .csv and .txt each getting the same result.
The number of fields and header data has been the same with no changes, so that shouldn't be the issue.
Any suggestions would be appreciated.
Thank you, in advance