Access crashing upon import of CSV files

[dougmcc1]

Every time I try to import a CSV file into my Access database it crashes. I've tried repairing it but the repaired database crashes as well. Any ideas on what could cause this?

Thanks.

 

[Treason]

does it work in a new database?

 

[dougmcc1]

Nope, I created a new database and table with the same number of fields and same field types as the original and got the same error:
"Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience."

 

[RuralGuy]

You are pushing Access in a manner that it cannot deal with (no kidding !). Try cutting down the length and width of the CSV file until you get Access to import something without crashing. Then build it back up 'til you find the problem again.

 

[dougmcc1]

I dont have control over how the CSV file is exported to us and it's too big to open in Excel. Anyway, we've imported much bigger CSV files in the past so I dont think it's the size.

Any other ideas? Thanks.

 

[Bat17]

try renaming it to .txt and bringing it in using the wizard, you get more controll that way.

I would also try bring it as a straight import rather than into a pre-made table, less likey to hit data mismatches then

Peter

 

[dougmcc1]

I didn't know you could import a file without having a table first, but I received the same error message in doing it that way. I also tried converting it to a text file and importing it but same problem.

Do you think it could be a problem with Access itself and not the database or file format? I'll try getting it reinstalled and see if that fixes anything. I'm still definitely open to any other ideas. Thanks again for all the feedback so far.

 

[ghudson]

Can you post a sample of your file [and db]? Remove or replace the sensitive stuff. Let somebody else test the file and see if it is just your install of Access or a limitation of Access. Ensure that your sample file also bombs on your computer before you post it.

 

[dougmcc1]

I reinstalled Access and now the import works fine. Thanks for the help.