I am using Excel and Access 2010. I have 7 Excel workbooks with multiple tabs with the same type of 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...
