| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2010 (64 bit) External Data connection with Access | Excel Discussion (Misc queries) | |||
| Excel data connection to Access | Excel Discussion (Misc queries) | |||
| workgroup access connection from excel | Excel Programming | |||
| Excel/Access connection via ADO | Excel Programming | |||
| Excel/Access connection via ADO | Excel Programming | |||
Linear Mode
