Microsoft.Jet.OLEDB.4.0 not running in 64 bit office 10

[panmat]

Can anyone suggest a work around for the following code......
Works perfectly with office 86 but creates error when running in office 64 bit

Please Login or Register  to view this content.

[Andy Pope]

Do these help?

http://social.msdn.microsoft.com/For...2bit-and-64bit
http://www.vbforums.com/showthread.p...EDB-4-0-on-X64

[panmat]

I have looked at these and tried lots of different suggestions to no avail......


'#####################################################################################################################
'
' Description: This tool is a simple macro which can be added to Excel to save the active sheet as DBF file.
'
' Author: Arnejan van Loenen
' Version: 1.00
' Date: March 1, 2011
'
'####################################################################################################################

Please Login or Register  to view this content.

When this code runs in office 2010 (86 enviroment) everything rus smoothly.
But in office 2010 (64 enviroment) after the save dialogue I get "Error Occurred, provider cannot be found. It may not be properly installed"

Please any ideas

[alansidman]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I have done this for you in the last post. Please adhere to this rule in the future.

[romperstomper]

Did you read the links carefully? There is no 64bit version of the Jet provider so you can't use it in 64bit Office - you have to use the Microsoft.ACE.OLEDB.12.0 provider instead.

[panmat]

Did you read the links carefully? There is no 64bit version of the Jet provider so you can't use it in 64bit Office - you have to use the Microsoft.ACE.OLEDB.12.0 provider instead.

This solved the problem thanks

[arlu1201]

panmat,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.