Need Help Importing Data into Access

  • Thread starter Thread starter Ken Boy
  • Start date Start date
K

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
 
To import the data from the old database, you are using File | Get External
| Import.

Instead, use File | Get External | Link. This creates a "shortcut" in your
database window to the data in the other database.

Now create a quey into the linked table.
In query design view, choose Append from the Query menu.
When Access asks which table to append to, nominate the new table.
Map the fields.
Run the query.

This imports the data from the old table into your new one. Once you are
happy with the results, you can delete the linked table.
 
In addition, to help avoid this problem, you should split your database.

here some links:
http://www.granite.ab.ca/access/splitapp.htm

http://www.microsoft.com/accessdev/articles/bapp97/chapters/ba15_3.htm

The real benefit here is that you can work on a separate front end, create
new form etc while your uses use a production front end. (which should be a
mde file).

When you are ready to deploy the new front end, you just have to give each
users a new front end.

Besides, it kind of makes sense to split the application from the data..
 
Back
Top