Adding records to existing table

[BartK]

Hello all,
I have a problem which it might be an easy fix. What I have is a database that I have done some tweaking on and in the meantime the original db has been in use which has added around 200 or so more records in the table.

What I would like to do is to just update the db that I have been working on with the older db table(the one who has the additional 200 records).

EX. DB A(Old DB, Newer Table) DB B(New DB, Older Table)

I want to put DB A table into DB B

Is this a simple fix? Or do I need to write some sort of query to update the records in the old table? I've tried to export the excel file and then import but it puts it in unrelated objects and then my switchboard or nothing works. Thank you in advance.

 

[Beetle]

I'm a little unclear here because it sounds like you are talking about an Access database table up until your last statement where you state that you attempted to export an Excel file. Are you working with Access? Excel? Some combination of both?

If you are working with Access, and assuming that the structure of the two tables is the same and that table B has no records that you want to keep, you can just delete table B and import table A from the other db (External Data/Access/Import). Make backup copies before you attempt any of this.

 

[BartK]

Beelte,
Thank you for your reply. I am indeed taking about access, I've tried to export the information from the table and then import it with no luck, also I have attempted to do what you suggested it does take the newer table and put it in the correct db however it puts it into unrelated objects. When it does that I cannot run any commands from my switchboard.

Thank you once again, if I'm being a little unclear about what I am wanting to do I can attach some pics of what I am having trouble with.

 

[Cronk]

You could have made it so much easier for your self if your db system was split into front and back ends.

That way, your user(s) could have happily continued working on maintaining the data in the tables while you 'tweaked' the functionality in the front end, linked to a test copy of the data tables. Then replaced the old version of the front end and reconnected to the backend.

Back to your immediate problem, how do you know that not only records have been added but which ones have been amended or deleted?

I'd delete all the tables from your updated db, and import from the db copy that has been worked on.

 

[BartK]

Cronk,
I've tried to delete the old table from the updated db and then import the updated table into the updated db, however when I do that it says that I have to delete the relationship between the 2 different tables. After I do that then bring over the new table, setup the relationships and try to run it it says "The Microsoft Acess database engine cannot find the input table or query. Make sure it exists and that it exists and that its name is spelled correctly."

Any thoughts?? Thank you once again.

 

[sumox]

i think you shud do easy task.

goto excel.
take backup of all Tables/DBs which u want to merge
copy table data one by one into excel sheet
insert a column row
name columns as per Db's table field names
delete both New & Old Table (not backup)
create new table, with same name as of was
the table field's type must be same as excel sheet
Copy from Excel
Paste to Access
I've done this many times

dets Simple !

 

[sumox]

sorry to forget
Don't Copy Data with Column names ! ever!

As itwill give error

 

[BartK]

sumox,
Thank you for your reply, however your approach would take me a very long time as I have approximately 1800 records total. I just never thought that copying, merging or appending; whatever way you want to slice it would be so complicated to complete. I can import the data into the new db however it does not place it in the appropriate group and therefore I cannot run any of my queries or reports from my switchboard.

 

[sumox]

why don't u use Append queries in ACCESS
There are also Delete queries in ACCESS
Just make any query thru Wizard.
You can change it in design mode, by right-click Query Type->...bla options

There's many lot automated ways you can easily do tasks
ACCESS is not a Heavy
You shud know, how to use it to automate tasks

Create form---> Controlbox-->Command button
here select Miscellaneous from wizard---> run query
then follow the wizard and fill what wizard asks you
now create all buttons

now if u know a little vba, then there's a Onload type property in form's
prop box. Insert some vba that all command button.click()= true (pls. do take correct vba codes, dont copy from here just for demo)

Now whenever you open this form, all tasks will be completed req.
data updation/query/deletion/merger/appending

 

[Cronk]

Maybe it's time to split the database (as it should have been in the first place).

(A) Take a copy of the db which has the extra records and delete everything except the tables.

(B) Then take a copy of the db where you have modified the functionality, and delete the tables only.

Then link the db in B to the tables in A.