Processing Excel data from within ACCESS VBA

[reglarh]

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!

 

[theDBguy]

Yes, you should be able to process an Excel data from within Access. You could try looking/searching on "Excel Automation" to see some examples on how to do it.