Importing an Excel file into Access

[TJunior]

I am trying to import an excel file into access, but am getting the following errors.

Method 'Columns' of object 'llmexGrid' failed

& then

An error occurred tring to import "...file name" The file was not imported.

The excel file is quite large. It consistes of 22000 rows and 14 columns. Is this outside the maximum number of rows supported by Access?

Please can you help me.

Thank you in advanced.

 

[carrr]

Not even close in most cases. Access 97 has a load limit of 1 gig, 2k 2 gig. You really can't hit it with the full amount, per se, but I doubt your record set is pushing these limits...
Are you pre-specing the table or are you letting Access create a new table as you bring the data in? If not, try letting Access "drive" and see what happens.

Occasionally, I experience problems with Excel files bringing them into Access. I usually can alleviate my headaches by saving my Excel file as a .txt. or .csv and then importing it into Access.