Importing Multiple entries into a form

[KayZee08]

Hi,

I'm fairly new to Access and have been given the task of altering an existing database at work. Currently we use a form to add entries to a list. These entries include the names and hyperlinks and other data on external files. However I need to add about 5000 entries to the database and since I cannot do it one by one using the form I was hoping to do it another way.

Currently all the 5000 entries I want to add are stored in an excel spreadsheet in the same format as my list, I was hoping that I could open up the "add entry form" and go to Datasheet view then just copy my spreadsheet into there and it would add all 5000 entries however it only lets me paste into one cell at a time, not the entire table.

Any ideas on how I could get the spreadsheet added to the list through the form, or alternate ways?

Thank You



Struggling Intern

[June7]

You could maybe use the import/link wizard.

It is possible to do copy/paste of multiple rows/records. The trick is to select the same fields in Access table in the same order as columns selected in Excel.

1. select cells in Excel

2. Ctrl+C

3. select fields in Access on a new record line

4. Ctrl+V

[KayZee08]

I have tried the ctrl+C, ctrl+V into the spreadsheet however it tries to paste all 5000 entries into only one cell. I think it may have something to do with the fact that the original form uses combo boxes and therefore when I change to spreadsheet view it does not like me pasting into it. I have attached an image of the spreadsheet and form view to show the fields that I am trying to enter and the excel spreadsheet is in the exact same format at shown.

[June7]

Don't copy/paste into form, copy/paste into table.