Table update problem

[BartK]

Hello all,
I've been having this problem and I can't seem to get any help on it. I've tried posting in the table and query forum, however I think it might be beyond that. Here is what I have:

DBA (older DB) DBB (newer DB)

I am wanting to take all the records in DBA tbl and put them into DBB tbl. I don't care if all records are overwritten or not. The reason I am wanting to do this is in the time it has taken me to make DBB (newer DB) more functional, records were still being added into the older DB tbl. I just want to copy all the old records and put them into the newer DB, but cannot seem to get it done.

I have tried to copy/paste the older DB tbl, append query and such. As far as I know both structures in both the tables are identical, so that shouldn't be a problem. Everytime I get close it puts the tbl into "unrelated objects" at the bottom.

Hopefully this isn't to confusing. Thank you all and have a good one.

 

[burrina]

In design mode open create a new query and add the table to it.
Drag the fields you want to populate or just bring down the * into the grid which is all fields. Next select make table from the menu and choose the destination table.
Next select run and Ta Da! Of course you can always append the data as well without not overwriting any records using a append query.

HTH

 

[bob fitz]

Why not use the wizard to import the table into "B" from "A".

 

[BartK]

Burrina and bob,
thank yo for your replies, Burrina I have tried that approach, however it places the table down in "unrelated objects" so when I try to run my queries and reports it is unable to being it is not "grouped" with the reports and such,

Bob,
I have tried your approach as well a while back which lead me to the module/vba forum. It to does give me the problem of putting my table back into the "unrelated objects" So as it stands right now I think that I will have to just make the corrections to the front end of the old DB to bring it up to what I need it to do.

Thank you all once again for your help, if you happen to think of another way that I can accomplish this please let me know.

Just a quick fyi, I have manually deleted all records in the new tbl of the new db and done an append. It does get the majority of the records, however there are some records that were not put in correctly so with that being said I think I will just have to make the changes on the DB they are currently using.

 

[bob fitz]

I have tried your approach as well a while back which lead me to the module/vba forum. It to does give me the problem of putting my table back into the "unrelated objects"

Not sure what you mean by "unrelated objects". I use A2003 and have recently installed A2013 as well. I am able to import the tables from an A2003 mdb file into a new A2013 accdb file without any issues.

 

[BartK]

Bob,
on the left hand side whenever you have access open it shows all related table/queries etc. within your db. Whenever I delete my table and then import the newest table it shows up down at the bottom under the tab "unrelated objects". Not really sure how to get it setup again. I have to delete my relationships to that table to delete it and then when I import the new table and re-establish the relationships my switchboard doesn't work. I have attached a snap shot of the db, please look it over and you can see what I am referring to.

Sorry to be vague about it. Thank you once again.