Importing Data

[Ken Boy]

Importing Data
Is there a way to import just the data from another Access database into the
current one? I am working on updating and changing some fields in a copy of
a functioning Access database.

My problem is that after I have made the changes to forms, etc, I want to
load in the existing data from the original database. What I get is that it
creates a dupe table such as customer1, from the original customer table. I
don't want to create another table I just want to move the data from one
table into another similar structured table.

I used to program in Paradox and it was a fairly simple procedure. Any help
would be appreciated.

Thanks, Ken

 

[Tim Ferguson]

Is there a way to import just the data from another Access database
into the current one? I am working on updating and changing some
fields in a copy of a functioning Access database.

Look up help on the INTO and IN clauses of the SELECT statement..


Tim F