Excel 64bit with vba script can not load data from Access 32 bit database

%3CLINGO-SUB%20id%3D%22lingo-sub-3203579%22%20slang%3D%22en-US%22%3EExcel%2064bit%20with%20vba%20script%20can%20not%20load%20data%20from%20Access%2032%20bit%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3203579%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%2C%20we%20have%20builded%20many%20years%20before%20some%20Excel%20file%20with%20vba%20code.%20This%20Excel%20file%20reads%20data%20from%20an%20Access%20database.%20In%20Office%2032%20bit%20everything%20was%20working%20fine.%20No%20we%20migrated%20to%20Office%2064%20bit%20and%20it%20is%20not%20working%20anymore.%20Now%20we%20have%20Excel%2064%20bits%20which%20is%20trying%20to%20read%20data%20from%20an%20Access%2032%20bit%20database.%20What%20is%20the%20best%20practice%20to%20fix%20this%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3203579%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eaccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3203789%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%2064bit%20with%20vba%20script%20can%20not%20load%20data%20from%20Access%2032%20bit%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3203789%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1236282%22%20target%3D%22_blank%22%3E%40Kem_Mal%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fexcel-64bit-with-vba-script-can-not-load-data-from%2F3b6a2ffc-350a-4898-a702-f0f0fe51477b%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ESame%20response%20as%20to%20your%20other%20post%20here.%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi, we have builded many years before some Excel file with vba code. This Excel file reads data from an Access database. In Office 32 bit everything was working fine. No we migrated to Office 64 bit and it is not working anymore. Now we have Excel 64 bits which is trying to read data from an Access 32 bit database. What is the best practice to fix this?

1 Reply