Getting Sheet Names with 64-bit software

[#1]

Hi,

I have tried Rob Wunderlich's Cookbook, as well as read the blog on the site about loading multiple sheets from a Workbook, but I am not succeeding.

I can't even create the ODBC Jet Connection, seeing as I am using 64-bit software and it doesn't support the Jet driver.

Is there another way of accessing the SQLtables?

If there is, could someone please describe it step by step.

Thank you very much.

Regards-

[ashfaq_haseeb]

Hi

If you are using V 10. Then in script editor select force 32 bit check box.

then check weather you get the required drivers.

Hope that helps

Regards

ASHFAQ

[disqr_rm]

Here are the steps. This will get you access to Excel files over 64-bit environment:

1 - Uninstall All Microsoft Office versions from server
2 - Download and Install these drivers (64bit version) - Microsoft Access Database Engine 2010 Redistributable
http://www.microsoft.com/downloads/details.aspx?FamilyID=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

Download and install AccessDatabaseEngine_X64.exe. Please note, you can only install if you have uninstalled all Office versions and supporting stuff, like compatibility packs, etc.

3 - If you want, you can Reinstall your Office

This worked to get access to MSAccess databases. I am sure, this will get you access to Excel files as well.

Hope this helps.

Rakesh

[#4]

Thank you very much for the suggestions, but these unfortunately won't work.

- Might wait until SR3 before the client goes over to QV 10

- Would not want to perform all the Office/Access operations on a client's server, although it is definitely a very good suggestion and something that I will refer back to in the future.

Any other suggestions?

[disqr_rm]

- Not sure why not SR2. I am looking forward to have it released today. I know many are waiting to get onto it. But I sure it's your client preference and not yours.

- Why not? Usually there is not MS Office or anything installed on the server so steps to uninstall ans re-install office products can be skipped. And for any 3rd party OBDC/OLEDB connections you will have to install the drivers.Again, this could depend on your client preferences.

Please don't forget to post back how you solved this issue finally, to help your fellow community members here.

Good luck!