Processing Excel data from within ACCESS VBA (1 Viewer)

reglarh

Registered User.
Local time
Today, 01:32
Joined
Feb 10, 2014
Messages
118
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

I’m here to help
Staff member
Local time
Today, 01:32
Joined
Oct 29, 2018
Messages
21,357
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.
 

Users who are viewing this thread

Top Bottom