Copy column from Excel to Access

[Lila Puri]

I do have 18000 rows to be copied from Excel to Access. When I do it, it gives error like copy/sharing limit exceed...
How can I do it?

[twinnyfo]

Lila Puri,

There are two primary ways you can do this.

First, you could link the spreadsheet to your database, then use he spreadsheet as one of the tables, and just append the records to your DB table.

Or, you could use MS Access VBA to automate the Excel operations, open the file, and copy the data, row by row until the import is complete.

Depending on what you need to do and if this is a regular import, both methods have advantages and disadvantages.