Data Connection from Excel to Access
 

Hi all,

I want to create dynamic data connection from excel 2007 to access mdb file
with vba and then list data table to worksheet.

I use "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\blabla.mdb;"
connection string.

But i have no idea about handling coming data and writing to the sheet.
Could anyone show an example to me?

Thanks in advance.