I need to populate three tables in an ACCESS database from data held in three Excel spreadsheets. However, each spreadsheet needs processing first, removing unwanted columns, renaming columns to used ACCESS field names etc.
I would really like all this, including the actual import to be handled by one ACCESS VBA codeset.
The real issue is can I process spreadsheet data from with ACCESS VBA?
Ideas welcomed!
I would really like all this, including the actual import to be handled by one ACCESS VBA codeset.
The real issue is can I process spreadsheet data from with ACCESS VBA?
Ideas welcomed!