| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
connect to Access 2007
"Tom Ogilvy" wrote:
try using Provider=Microsoft.Jet.OLEDB.12.0 Also check the name of your access file extension. MDB might be something like ACDB This connection string worked for me: "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myDatabase.accdb;" Hope this helps. -- urkec |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I connect to access 2007 data from excel? | Excel Discussion (Misc queries) | |||
| Excel VAB+ADO connect ACCESS with SQL | Excel Programming | |||
| Connect to MS Access with Password via VBA | Excel Programming | |||
| Help with using ADO to connect Excel to Access | Excel Programming | |||
| ADO Connect Access | Excel Programming | |||
Hybrid Mode
