AllExperts > Ingres 
Search      
Ingres
Volunteer
Answers to thousands of questions
 Home · More Ingres Questions · Answer Library  · Encyclopedia ·
More Ingres Answers
Question Library

Ask a question about Ingres
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Jean-Pierre Zuate
Expertise
Any questions about database Ingres (owned by Computer Associates then Ingres Corp) : - Ingres 6.4 - OpenINGRES from 1.0 to 2.0 - IngresII from 2.0 to 2.6 - Ingres R3, Ingres 2006 (Open Source version) - All tool around Ingres : ABF, Report Writer, Replicator, OpenROAD (3.5 to 2006), Ingres/NET Ingres/STAR, ...

Experience
16 years of computing experience as :
- AS400 programmer
- AIX / Ingres administrator and developer (OpenROAD and korn shell)
- Ingres DataBase Administrator
- Ingres expert - Data modelisation - ETL - Reporting - Many of Computer Associates sofwares - ITIL / CMDB / Change Management

Organizations
http://lafageconseil.fr

 
   

You are here:  Experts > Computing/Technology > Databases > Ingres > import *.mdb files to ingres in Linux

Ingres - import *.mdb files to ingres in Linux


Expert: Jean-Pierre Zuate - 2/26/2008

Question
Hi,
I am new to Ingres and I am just installing ingres2006-9.0.4-104-NPTL-gpl-pc-linux-i386.tgz in RedHat9. Then here comes two questions confusing me.

The first is when I use usr:"ingres" login, cd "/opt/Ingres/IngresII/ingres" to execute the version.rel, "permission denied" popup.
And the second (the most important one) is I really don't know how to import *.mdb files to ingres DB in Linux. Could you tell me how to do this or there's another file I have to
install?

Thanks in advance
Beck

Answer
Hello,

You do not have to execute the file version.rel. This file contain the version of Ingres (a litteral). Why do you want to execute it ?

MDB files are Access files. Without a third party tool (as an ETL) to read data from mdb file and to write it onto Ingres or export each table from access to csv file and recreate them in ingres, no solution here.

To import data in Ingres via csv file you must use the Ingres Import Assistant. This is a graphical tool. It come with Ingres on WIndows only (this part of Ingres is not open source but still free).

If you are new to Ingres you can have a look at this page : http://docs.ingres.com/ and check for some guides like :
- getting started guide
- quick start guide for windows (and linux)
- Ingres for linux getting started

You'll find here some helpful informations about Ingres on these platform and tools assiciate to Ingres.

Hope this help,
Kind regards.
Jean-Pierre ZUATE
http://lafageconseil.fr  

Add to this Answer   Ask a Question


 
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.