How can I paste many new records into a data table

[Roger]

I have a small database with several tables, the main one being MyData
table. I add records to MyData table with a form, but sometimes I get 50+
new records in an Excel spreadsheet. I have the spreadsheet set up with
exactly the same number and format of columns as the table has fields, but
when I try to copy from Excel and paste the new data into Access MyData
table it won't do it, I just get an error. I am using Access 2002 sp3.

Surely there is some way I can append new data to a table without entering
it via a form item by item, but I can't find it. Can someone help me, please
?

Rod

 

[Guest]

Look in Help for TransferSpreadsheet
It is for importing and exporting data to and from Excel.

 

[Guest]

Hi Roger,

Try linking to the Excel spreadsheet by going to the menu bar.
Selec File, Get External Data, Linked Tables.
Change the Files of Type dropdown to Microsoft Excle (*.xls) .
Find the Excel spreadsheet in questionand click on Link button.
Follow the Link Spreadsheet Wizard.

After that you can create an append query based on the linked spreadsheet to
put the records into your table.

You just might want to make a backup copy of the database first in case
something goes wrong. However, you'll find that it isn't all that difficult
of a process after you've done it a few times.