View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
urkec urkec is offline
external usenet poster
 
Posts: 131
Default 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