Text File import in Access

[raj08536]

Text File with 4,400,000 records import in Access. It say Bad file name or number.

 

[jackd]

?? Want to show us the info/code you used to import the data?

 

[raj08536]

Thanks for your response.

No I am not using any code. Can you please suggest help me writing a code. Here is my CSV file.

 

[Joe4]

What exactly is the name of your CSV file?

 

[raj08536]

"C:\SFR GLTotals\SFR_GLTotals_2021.csv"

 

[Joe4]

What is the total size of the CSV file?
Access has a 2 GB limit on the size of a database.
If you add up the current size of the Access database and the current size of the CSV file, does it exceed 2 GB?

Also, instead of importing the CSV file into an Access table, have you tried just linking the file to Access?
That won't take up much memory in Access.

 

[alicooper169]

Text File with 4,400,000 records import in Access. It say Bad file name or number.
View attachment 58586

Hello,

Please follow the below link to fix the Error:52

Bad file name or number (Error 52)

Thanks,

Ali Cooper