error, macro importing query data; Method 'DBEngine' application failed

[crobaseball]

Having probs with a macro I'm writing in Excel. Basically, I'm trying to import data a query in Access creates, into Excel. I think it's an error where I'm not referencing the right library, but I'm not sure. Below are screenshots of the error box I'm getting, the code which is highlighted when I go to debug, and the references I have selected. Thanks!

[rpeare]

if you're going to use a DAO object you likely need microsoft DAO 3.6 object library.

Just as a side note you *should* be able to access the database/recordset objects with microsoft access xx.x object library as well without having to use the dao.object

i.e.

dim db as database
dim rst as recordset

[andy49]

Where's the Microsoft dao reference? You should have it


Sent from my iPhone using Tapatalk

[crobaseball]

So for whatever reason, the DAO library has disappeared from my laptop. It's not listed in the reference list (I am putting a screen shot in here to show I'm not crazy; otherwise, I'd be happy to have someone point out what I'm missing). A.) How can I download this library and B.) Where should I save it?

Thanks!!

[crobaseball]

Ok, so I think I need a different file. When I look here: http://allenbrowne.com/ser-38.html
it seems to look like I need this: C:\Program Files\Common Files\Microsoft Shared\Office14\acedao.dll
since my access file is a .accdb type. But when I go to that folder, that .dll file doesn't exist. Any thoughts?

[crobaseball]

I figured it out! The "Office 14.0 Access database engine Object Library" (which I think is the library I was referring to in the previous post), can't be prioritized under the "Microsoft Access 14.0 Object Library". I simply moved the former above the latter in the priority list, and presto, my macro worked great. Here's what it should look like: