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.
|