Can I merge 2 Excel spreadsheets into 1 Access database?

  • Thread starter Thread starter New2Access
  • Start date Start date
N

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.
 
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.
Click to expand...

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
 
Back
Top