I am using Excel and Access 2010. I have 7 Excel workbooks with multiple tabs with the same data need to be imported into a single Access 2010 database. Each tab has identical field names with different number of records. I would like to import automatically by some type of VBscript or macro within Access.
Here are the field names: Object Class, Expenditure Type, Requirement, Description, Basis of Estimate (BOE), Priority (ie Must Pay, Mission Critical, Mission Imparied), Vendor, Contract Year, Period of Performance (POP), Contract Type, Contractor, FTE, If Capital Equipment -- Provide dollar amount, Oct, Nov, Dec, Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Total Spend Plan, FY12 EOY Actuals, Qtr1 Plan, Qtr1 Auth, Qtr2 Plan, Qtr2 Auth, Qtr3 Plan, Qtr3 Auth, Qtr4 Plan, Qtr4 Auth, Annual Plan Total, Total Auth, Tab, Div.
Thank you.