Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Reading Excel

Posted on 1997-10-03
Medium Priority
Last Modified: 2010-04-04
Can anyone tell me whats the proper way to setup the odbc drivers for accessing a excel spread sheet. I can get a database but no tables. The excel file in question as 3 spread sheet in side.  
Question by:mike459
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
  • 3
  • 3

Expert Comment

ID: 1346785
Why don't you use the TExcel component?
You can find it on the web.
Why reinventing the wheel if it already exists?

Author Comment

ID: 1346786
Thanks. do you know were to get TExcel?

Thanks again

Accepted Solution

ZifNab earned 300 total points
ID: 1346787
Sure, hope this is what you're looking (with all the functionality, you need) for :

TAExcel (Advanced version of TExcel) :

TExcel (Excel version of original author:

ExcelDemo (Demo version of how to use DDE communication) :

Have fun,
c.u. ZifNab;

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.


Author Comment

ID: 1346788
thanks !! I hope this works

I'll Let you know

Thanks Again
Mike C

Expert Comment

ID: 1346789
No problem, glad I could help.
It would be great to hear how it ends.
Have fun, using the component.
c.u. ZifNab;

Author Comment

ID: 1346790
I got the componment, but what it does is pump data to a excel spread via DDE. What I need to do is read a spread sheet from disk. What I have is a schedule done in excel thats on a server, also I have a job tracking software I wrote. What I want to do is read the data from the spread sheet via ODBC and display in my software(Job tracker) which is on another server.

So thanks anyway if you have any othe ideas it would be great.
thanks again Mike C

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
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

670 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