Solved

Read excel xls on 64 bit machine

Posted on 2011-02-23
8
529 Views
Last Modified: 2012-05-11
.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?
0
Comment
Question by:hongjun
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 34967832
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
 
LVL 33

Author Comment

by:hongjun
ID: 34967836
It is working on 32 bit but not 64 bit.
0
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 34967886
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
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 
LVL 70

Accepted Solution

by:
Éric Moreau earned 500 total points
ID: 34968762
0
 
LVL 33

Author Comment

by:hongjun
ID: 34969528
it is a website
0
 
LVL 33

Author Comment

by:hongjun
ID: 34969565
erm.. aspose looks ex.
anyway, I just wish to confirm there is no direct method.
0
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 34969775
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
 
LVL 33

Author Comment

by:hongjun
ID: 34969791
Yes, let's leave this thread open for a few more days and see if there are more inputs.

Appreciate both of you.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question