Don't understand what you mean by "only when headers dont.change for access table". Access tables don't have headers, they have fields that have names. Maybe you mean something else, like one time you're writing to one table, and another time it's a different table.
As for whether or not it's possible via vba, I'd have to say yes although I've never tried. I have controlled Excel from Access though, which I think is more common. The principles should be the same, but the burning question is, why would you when you can use TransferSpreadsheet function from either app, or import (link or not link) worksheets from the Access side, or export from Excel.
