Help

Merge Tables

Solved
Jump to Solution
227 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Juan_Ferrari
4 - Data Explorer
4 - Data Explorer

Hi, I use to have 1 data base for sales, delivered or not, but for some reason I thought It would be faster for searches and stuff to leave the delivered sales in anothe identical table. So I duplicated the table and erased the records that were "to deliver"in the delivered and "delivered" in the non delivered.

It didn't worked as planed and now Im trying to go back, but I can't find the way.

I just need to merge them back into one. Is there any simple way?

 

Thanks
Juan

1 Solution

Accepted Solutions
Sho
10 - Mercury
10 - Mercury

It is easier to copy and paste records if you create a plain View with no filters and no sorting set up. You can add records without overwriting them by pasting them into the last row.

See Solution in Thread

4 Replies 4
Sistema_Aotearo
7 - App Architect
7 - App Architect

You should be able to copy and paste. With the expand table option might help too.

You can also export the new table to a csv and then re-import to the original?

Sho
10 - Mercury
10 - Mercury

It is easier to copy and paste records if you create a plain View with no filters and no sorting set up. You can add records without overwriting them by pasting them into the last row.

Thanks for the reply.

 

It has pictures and pdfs in it, copy and paste is not working.

CSV file is not working too.

Any other Ideas?

 

Fixed it, it was the orther of fields was the problem.

Thanks