Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Opening CTREE DOS with MS Access 2003

Posted on 2006-11-09
10
Medium Priority
?
882 Views
Last Modified: 2008-01-09
I have a client that is using a DOS program based in CTREE. The tables have a .db and .dbi file extension. I am creating a new program for them in MYSql and MS Access. I have thus far not been able to open any of the tables using Access or Excel. I need to be able to get the historic data out of the tables to populate the new tables. When I attempt to open the tables in Excel, I get a message that states "This file contains queries ti external data. Queries are used to imprort external data into Excel, but queries can be designed to access confidential information . . ." I click OK and get the following message; "External table is not in the expected format." Do I need an ODBC (datasource) driver to access this data. If so, where can I get the driver (datasource).
0
Comment
Question by:ergenbgr
[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
  • 2
  • 2
  • +1
10 Comments
 
LVL 65

Expert Comment

by:rockiroads
ID: 17907001
try using a ODBC driver from Access, see if that helps
http://www.faircom.com/products/driversdk/
0
 

Author Comment

by:ergenbgr
ID: 17907179
I have tried all the ODBC drivers that come with ACCESS, none work. I get the same error message. I checked Faircom's site and it appears that one must own a Ctree license to be able to purchase the ODBC for $169.00. I was hoping for a less expensive solution. Thanks for your comments rockiroads.
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17907605
Sorry mate, the only way I know how to extract info is to use some kind of ODBC driver.
Have u searched google for CTREE ODBC Drivers?

0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
LVL 65

Expert Comment

by:rockiroads
ID: 18282255
Could this be PAQed instead? only because of the link I gave, this may prove some use to someone who wishes to obtain a ctree odbc driver.
0
 

Author Comment

by:ergenbgr
ID: 18283827
Sorry, I am not familiar with the acronym PAQ. Please enlighten me. Thanks
0
 
LVL 61

Expert Comment

by:mbizup
ID: 18284000
ergenbgr,

I just noticed that you are relatively new to Experts-Exchange.  First off, welcome aboard.  PAQ means Previously Asked Question.  Basically the question is saved in the database, not deleted.  Please take some time to read this part of the helpfile about closing and grading your questions:

http://www.experts-exchange.com/help.jsp#hs5
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 18284427
Further to what mbizup has said


I havent given you a solution worth accepting but I feel the information I provided may be of use to someone therefore I suggested a PAQ/Refund. The question is closed but not deleted.

If u want to continue with this question, u might need to ask a 0 point refresher question so that experts can see it (ask mods I think) - is that right Miriam?

If u want to close it, the usual practice is u have to request closure by asking a question in community support.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 18285266
I think you can post a pointer question through EE-Stuff.com now.  A 20 pt question containing the URL to this one works as well.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 18320556
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

610 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