Unrecognized DB Format Error 3343

[bubbapost]

Hello,

Excel & Access 2007.

I am trying to import a query from Access into Excel and I keep getting this error "Error 3343 Unrecognized Database format". Can anyone help me?

Here is my code:

Sub Import_Agent_Info_DAO()
Dim strDB As DAO.Database
Dim strQD As DAO.QueryDef
Dim strSet As DAO.Recordset
Dim WSA As Worksheet
Dim WSS As Worksheet
 
Set WSS = ThisWorkbook.Worksheets("Submit")
Set WSA = ThisWorkbook.Worksheets("AgentList")
 
Set strDB = DBEngine.OpenDatabase("C:\Users\bubbapost\Desktop\Agents.accdb")
Set strQD = strDB.QueryDefs("QryAgentInfo")
 
Set strSet = strQD.OpenRecordset
 
WSA.Range("A2").CopyFromRecordset strSet
 
With WSA.Range("A1:E1")
    .Value = Array("ID", "Agent", "Site", "Team Lead", "Division")
    .EntireColumn.AutoFit
End With
 
End Sub

 

[Cloverken]

Sounds like your DAO is not current.

See this link.

http://allenbrowne.com/ser-38.html

check your computer to see if you have up to date DAO Library at the following spot on your computer

C:\Program Files\Microsoft Office\Office12\acedao.dll

to reinstall

http://www.filerepair.ca/DLL-EXE-downloads/a/ac/ACEDAO.DLL-Download-File-ACEDAO.DLL.html