Can I merge 2 Excel spreadsheets into 1 Access database?

[New2Access]

My company uses the CRM software SalesForce. We have clients who sponsor
local programs. Therefore, we have 2 different sides to SalesForce where we
save data- Sponsors and Local Programs. Sometimes we need to merge data from
both sides. Is it possble to do this easily in Access, because we have been
using Excel but that leaves much room for human error, and takes a good bit
of time.

 

[KARL DEWEY]

Just append them to the same table.

 

[usersfirst]

My company uses the CRM software SalesForce. We have clients who sponsor
local programs. Therefore, we have 2 different sides to SalesForce where we
save data- Sponsors and Local Programs. Sometimes we need to merge data from
both sides. Is it possble to do this easily in Access, because we have been
using Excel but that leaves much room for human error, and takes a good bit
of time.

If your two spreadsheets contain the same column headings (which I
would imagine they do) you can import the first spreadsheet, then when
importing the second spreadsheet, choose to add it to the existing
table instead of creating a new one. Provided the column names are
the same, you'll be set. If you do this frequently, you can create a
macro to automatically import your spreadsheets using the
TransferSpreadsheet method.

Cheers
Brandon
http://www.opengatesw.net