Here are some hints for you to do the job - not saying it is the most elegant but it is good for a one-timer :)
In Excel you can use ADO to connect to the Access database:
dim con as New ADODB.Connection
dim rTable as ADODB.Recordset
dim sSqlTable as String
con.Open "driver={Microsoft...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.