Community archive

Ask something
Discussion Locked

Import to Access from Excel

0 helpful
1 reply

by sholmes

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to inport Excel worksheets into Access2000. In Access, i use the, get external data, option and choose and excel file that i want to import. The excel files contain anywhere between 2,000 to 16,000 records. I am importing the records tothe same table in access. When the access table gets to around 25,000 records and i try to import more, the program locks up and wont do it. Does access have limits to how much you can import according to how much info is already in the table? I am trying to do this on a machine running winNT 4.0, PIII 500, 128meg RAM, 6 gig HD with 3 gig free. Any help would be greatly appreciated.
PS. the excel files contain one worksheet with 6 colums of text data.

1 reply

by dennawehrle

I frequently have the same problem when importing large membership files. The workaround I found that works the best is to first export your data into a delimted text file and then import the text file into Access. Let me know if it works for you!

This discussion is closed to new replies.