Import Access database recordset into Excel

well, what you mean 'it not working'? did it break and work before? also i believe you have to make records visible. you do that by moving to last record and then back to first. if you do not do this only first record is seen by environment. loop ends after 1.

It works with an .mdb file but not with an .accdb file

hmmmm.....maybe the accdb file needs to have done what i said?

this is the complete code

Please Login or Register  to view this content.

the code did not change. the code that is issue for you. in the last post, it looked the same as previous code you posted. so not sure what to say. you never did say though what was not working. line of code? you step line by line with it? other issue that see is that you are not destroy memory. maybe that is it?

Attached the files with mdb and accdb extension and the corresponding excel files

your original code for me resulted in first image below. when i changed that code to this

Please Login or Register  to view this content.

i got what you see in second image below. now, 'opendatabase' has 3 methods guess

https://docs.microsoft.com/en-us/off...ase-method-dao

https://docs.microsoft.com/en-us/off...s.opendatabase

https://docs.microsoft.com/en-us/off...ase-method-dao

but one those is for inside access. and one them applies to treating workbooks like databases. this one

https://docs.microsoft.com/en-us/off...s.opendatabase

that one i used to test. that's why second image below looks like that.

so, issue might be that you swtiched from 32 bit office to 64 bit office, or could be that now you using later version of office. look at articles i post. see that years? they only apply to 2013. so that be the problem maybe??

THX the problem is resolved

K good.......nice!