Quote Originally Posted by Spoo View Post
Marty

Short answer, seems to me, would be to write a macro using Excel VBA that ,,
1. Reads the Access file
2. Writes to the Access file
3. Does other stuff on a spreadsheet in the Excel file.

I have not specifically tried this, but, despite the fact that VBA is a crippled
version of VB6, I imagine that it is doable using VBA.

How do you plan to (ahem) access Access?
DAO
ADO

If DAO, and you need some further help, holler.

And, oh yeah, what happened to your other thread?

Spoo
1 to 3: Yes that's exactly want I want to do and other than the apparently non-trivial task of actually opening the database (read on) I'm sure I can do it with ADO. As for my other similar thread I thought it got off to a bad start so I decided to try again.

@westconn1: The database I created via Access 2010 wound up with an extension of accdb and I get an "AutomationError Unspecified Error" on this line.
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "C:\MyPath\test.accdb"