Importing in Access from Excel creating relationships

[AF]

Hi,

I am hoping someone can help me with this question. Problem: we ended up
with 2 copies of the access database and need only one containing all of the
information. Could not copy and paste the data from one table/database to
another and there are too many records to easily re-write them in the table
on the main database. So I exported them to excel for the main table, copy
and pasted from the other table into this new excel document, creating one
master excel document with all the information needed to be in Access. When
I save a copy of the main table (keeping only the structure) and then try to
import the excel file back into access I lose all the relationships. Is
there anyway to create relationships/maintain the relationships during this
import. I need to have the drop down menus for a number of fields so data
can still be added easily.

Thanks so much

A

 

[Jeff Boyce]

We aren't there. We can't see what you are working with.

What "relationships"?

?"2 copies of the access database" ... do you mean two tables?

Have you looked into using either update or append queries to modify records
in a table?

Regards

Jeff Boyce
Microsoft Office/Access MVP