Read excel xls on 64 bit machine

.NET related question:

I have problems trying to read excel xls on 64 bit machine.
Am aware there is no direct method but then any suggestion for less rework?
LVL 33
hongjunAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Éric MoreauConnect With a Mentor Senior .Net ConsultantCommented:
0
 
Carl TawnSystems and Integration DeveloperCommented:
Do you have code to read from Excel, but it just isn't working on 64-bit? Or do you not have code to read from Excel full stop?
0
 
hongjunAuthor Commented:
It is working on 32 bit but not 64 bit.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Carl TawnSystems and Integration DeveloperCommented:
Have you compiled your app specifically for x86?

There isn't currently an native 64-bit version of the Jet drivers available, so if your app is compiled with the "Any CPU" setting then it will attempt to use 64-bit drivers when on a 64-bit OS.
0
 
hongjunAuthor Commented:
it is a website
0
 
hongjunAuthor Commented:
erm.. aspose looks ex.
anyway, I just wish to confirm there is no direct method.
0
 
Carl TawnSystems and Integration DeveloperCommented:
Well, using ADO.Net with the Jet drivers is a direct method; or at least more direct than using Office interop. It's just that there are issues with the Jet drivers on 64-bit systems.
0
 
hongjunAuthor Commented:
Yes, let's leave this thread open for a few more days and see if there are more inputs.

Appreciate both of you.
0
All Courses

From novice to tech pro — start learning today.