Copying an Excel table into an existing Access table?

[Guest]

I have an excel table containing 13,000 records (rows) of four variables
(columns). I also have a huge access database into which I need to copy this
data. There is an existing table with 22 records to which I want to copy the
13,000 into. I'm a fairly inexperienced Access user. I tried copying and
pasting the entire 13,000 records onto the end of the existing table. Access
couldn't handle that much data at once. I also tried importing the data, but
like another user posted, the option to import into an existing table is
greyed out. I also tried copying the the existing 22 Access records into the
Excel file and copying the whole table back into Access - again, too large.
Finally, I started copying about 300 records at a time. Not ideal, but it was
working. At some point, after pasting in about 5,000 records, Access stopped
allowing this and only wanted to copy a line at a time. Can someone suggest
an easy way to tack on the last 8,000 records? Will it work if I copy the 22
Access records into the Excel file, delete the existing Access table and
import the whole Excel file into Access as a new table. Thanks all.

 

[Ken Snell \(MVP\)]

Use File | Get External Data | Import to import the EXCEL spreadsheet's data
into a new table. Then use an append query to copy the data into the
permanent table.