Home

ODBC driver issue in Macro VBA

%3CLINGO-SUB%20id%3D%22lingo-sub-844893%22%20slang%3D%22en-US%22%3ERe%3A%20ODBC%20driver%20issue%20in%20Macro%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-844893%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F405224%22%20target%3D%22_blank%22%3E%40Mike1983%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ethis%20may%20not%20be%20what%20you%20want%20to%20hear%2C%20but%20the%2064%20bit%20version%20of%20Office%20should%20really%20be%20the%20default%20installation%20these%20days.%20It's%20only%20a%20few%20legacy%20add-ins%20that%20still%20require%2032%20bit%20Excel%20and%20you%20may%20not%20even%20run%20these.%26nbsp%3B%2064%20bit%20Excel%20can%20use%20more%20of%20your%20computer's%20memory%20and%20will%20run%20better.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-856225%22%20slang%3D%22en-US%22%3ERe%3A%20ODBC%20driver%20issue%20in%20Macro%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-856225%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E.%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20reply.%20I've%20re-installed%20from%2032-bit%20verstion%20to%2064%20bit%20and%20now%20it%20is%20working%20when%20use%20XLSX%20and%20XLS%20fiels%20created%20on%20this%20version%20of%20Excel.%20However%2C%20if%20I%20try%20to%20use%20XLS%20file%20created%20before%20when%20I%20was%20using%2032-bit%20version%20it%20is%20still%20the%20same%20problem.%26nbsp%3B%20So%20it%20is%20working%20once%20I%20am%20comparing%20XLSX%20with%20XLS%20both%20created%20on%2064%20bit%20Excel%20version.%3C%2FP%3E%3CP%3EI%20am%20still%20wondering%20if%20there%20is%20any%20way%20to%20handle%20the%20case%20when%20file%20was%20created%20on%2032-bit%20Excel%20version.%20I%20understand%20that%2032-bit%20is%20becoming%20legacy%20but%20if%20you%20got%20a%20file%20like%20this%20then%20you%20are%20stuck%20and%20macro%20will%20not%20go%20ahead%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBtw%20-%20first%20phrase%20was%20in%20Polish%20and%20it%20is%20%22odbc%20driver%20does%20not%20support%20the%20requested%20properties%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842456%22%20slang%3D%22en-US%22%3EODBC%20driver%20issue%20in%20Macro%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842456%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20ve%20got%20an%20issue%20with%20ODBC%20driver%20once%20using%20Macro.%20In%20very%20short%20Macro%20works%20fine%20when%20I%20am%20using%202%20xlsx%20files%20(it%20compares%20some%20data%20so%20firstly%20I%20am%20selecting%20and%20loading%202%20files).%20However%2C%20it%20shows%20an%20error%20like%20this%20when%20I%20am%20comparing%20%3CSTRONG%3Exlsx%3C%2FSTRONG%3Efile%20with%20%3CSTRONG%3Exls%3C%2FSTRONG%3Efile.%20I%20can%20select%20both%20files%20but%20when%20I%20try%20to%20go%20ahead%20(clicking%20NEXT)%20an%20issue%20appears.%20I%20have%20office%20365%20(32%20bit%20version)%20and%20what%20is%20interesting%20my%20colleague%20has%2064%20bit%20version%20and%20when%20he%20is%20using%20other%20files%20xlsx%20and%20xls%20it%20is%20working%20fine%20for%20him.%20Theoretically%20I%20could%20try%20to%20re-install%20office%20but%20want%20to%20be%20sure%20what%20is%20the%20reason%20as%20I%20don't%20want%20to%20tell%20all%20the%20users%20to%20re-install%20office%20to%2064%20bit%20versions%20if%20they%20face%20the%20same%20issue%20on%20their%20machines.%20Or%20what%20other%20solutions%20could%20be%20applied%20here%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPS.%20first%20phrase%20below%20on%20Error%20message%20(not%20in%20English)%20it%20is%20%22odbc%20driver%20does%20not%20support%20the%20requested%20properties%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%2C%3C%2FP%3E%3CP%3EMichal%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20621px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130594i5FD1B922AED8D92A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22odbc%20driver.png%22%20title%3D%22odbc%20driver.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-842456%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Mike1983
New Contributor

Hi,

 

I ve got an issue with ODBC driver once using Macro. In very short Macro works fine when I am using 2 xlsx files (it compares some data so firstly I am selecting and loading 2 files). However, it shows an error like this when I am comparing xlsx file with xls file. I can select both files but when I try to go ahead (clicking NEXT) an issue appears. I have office 365 (32 bit version) and what is interesting my colleague has 64 bit version and when he is using other files xlsx and xls it is working fine for him. Theoretically I could try to re-install office but want to be sure what is the reason as I don't want to tell all the users to re-install office to 64 bit versions if they face the same issue on their machines. Or what other solutions could be applied here?

 

PS. first phrase below on Error message (not in English) it is "odbc driver does not support the requested properties"

 

Please help,

Michal

 

odbc driver.png

2 Replies

Hello @Mike1983 ,

 

this may not be what you want to hear, but the 64 bit version of Office should really be the default installation these days. It's only a few legacy add-ins that still require 32 bit Excel and you may not even run these.  64 bit Excel can use more of your computer's memory and will run better.

Hello @Ingeborg Hawighorst

Thanks for reply. I've re-installed from 32-bit verstion to 64 bit and now it is working when use XLSX and XLS fiels created on this version of Excel. However, if I try to use XLS file created before when I was using 32-bit version it is still the same problem.  So it is working once I am comparing XLSX with XLS both created on 64 bit Excel version.

I am still wondering if there is any way to handle the case when file was created on 32-bit Excel version. I understand that 32-bit is becoming legacy but if you got a file like this then you are stuck and macro will not go ahead

 

Btw - first phrase was in Polish and it is "odbc driver does not support the requested properties".

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies