Jump to content
  • 0

VW connection to Ecxel via ODBC doesent work


deepImplement

Question

Heyo,

I just tried to connect VW 2019 with a Ecxel document over the ODBC connection to transfer data.

I try to use this Tutorial from @Miguel Barrera

 

The Problem I have is when try to choose the dataconnection in VW, the options are not givin:

grafik.thumb.png.02d3a3dc24dc678adc36905c55df47d0.png

 

I create connections in the ODCB Manager tfor every Ecxel Driver who exist:

grafik.thumb.png.5988b11c05254956ed0fa2fafa3806db.png

 

Why isnt this working in VW?

 

I try to run VW with Admin Rights but still no result in the list.

Link to comment

1 answer to this question

Recommended Posts

  • 0

In windows there are multiple copies of odbcad32.exe so you need to find which one is visible to VW. I did a search on the windows folder and found 4 copies. The most relevant however, are located in the C:\WINDOWS\SysWOW64 folder, which applies to 64 bit applications, and the other is in the C:\WINDOWS\System32 folder, which applies to 32 bit applications. If it does not appear in the VW dialog, then you need to configure the other odbcad32 administrator.

 

In my system, I found that the one in SysWOW64 works with VW.

  • Like 1
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...