I just got the new office installed on my computer and facing some problems...My question is regarding Excel VBA and access. Earlier, in 2003 version, I was using the following driver for accessing Access through excel:
con.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"data source =D:\reports\eds\reports.mdb"
But now, in Access 2007 version Formats, the mdb extension is changed to accb. Can anyone please tell me that which Driver we need to download or use to make it work?
Thanks,
Vikas
Bookmarks