Tables to feed into main table

[Titanium_Link]

I recently got Microsoft Access 2007 to help with book keeping. I sell some stuff on eBay so generate both bank transaction and PayPal transactions so I was hoping to set up Access so that the table of eBay transaction and a separate PayPal transactions table feed into a main table which sorts the transactions by date order. Any idea how I would do this?

Thanks

 

[pbaldy]

I would probably have a single table with a field for the source. Are the fields very different? If you really need 2 tables, you can use a UNION query to join them.

 

[Anakardian]

I would use the two tables you mention from ebay and paypal as the place where I import data.
For my own use I would strip out those fields I need from both tables and have them in a single table. As pbaldy said, this would contain an indication of whether it is an ebay or paypal transaction.
A big part of the process from the import table to the final table is cleaning out the data to avoid duplicates as well as making sure any updates are applied correctly.