Beginnner needs help!

[smhill]

I'm rather new to Access, but I have to get this done fast. I have two separate databases: one in table form with all my records and fields; and another that is empty, with the exception of 3 preformatted forms and corresponding tables. My employer wants me to transfer all data from database 1 into the forms in the other. Is there a way to do this without having to re-enter all of my data?

 

[AlaskanDad]

Start with the database that has the forms in it. Go to the File menu and select Get External Data...Import... Find your database with the full tables and double click on it. Select all of the tables you want to bring over and click OK. They will be brought over to your forms database.

If the tables that were already there have the same name, the new names will have a 1 after them. If the formats of the pre-existing, empty tables are the same as the ones you just brought over, you're in luck. All you have to do is delete the empty tables and then remove the 1 from each of the newly imported tables. Everything would be connected as you needed it to be.

If the formats are different you will have to cut and paste your information or run an update or append query.