LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 03-25-2007, 10:44 AM   #1
arindom
Member
 
Registered: Nov 2006
Location: India
Distribution: Ubuntu 11.04
Posts: 165

Rep: Reputation: 30
How to open Access files in Base


Distro - OpenSuse 10.2

I am trying to open an MS-Access file (version may be 2000) in Base but nothing is showing when the file is opened. Neither the tables nor the forms, nothing. In Kexi I am getting the message ...

"Import failed ... No appropriate migration driver found "

This file is opening correctly in Access. I tried ODBC driver setup also. But there is nothing found in ODBC driver selection.

Please suggest how should I open it. Please advise step by step as I am not an advanced user.
 
Old 03-31-2007, 04:37 AM   #2
ZioFester
LQ Newbie
 
Registered: Mar 2007
Location: Italy
Distribution: kubuntu
Posts: 1

Rep: Reputation: 0
Distro kubuntu 6.10

I have the same problem.
everything I try...

Someone can help?
 
Old 03-31-2007, 08:59 AM   #3
pixellany
LQ Veteran
 
Registered: Nov 2005
Location: Annapolis, MD
Distribution: Arch/XFCE
Posts: 17,802

Rep: Reputation: 728Reputation: 728Reputation: 728Reputation: 728Reputation: 728Reputation: 728Reputation: 728
Google is your friend...I used "access files open office" and got several promising hits.

http://www.openoffice.org/FAQs/mostfaqs.html#9
Look at FAQ #9
 
Old 03-31-2007, 10:23 AM   #4
arindom
Member
 
Registered: Nov 2006
Location: India
Distribution: Ubuntu 11.04
Posts: 165

Original Poster
Rep: Reputation: 30
Thanks for the link. Though my problem seems to be there. The guide was mainly for windows. I tried the "Creating a Data Source within OOo" section. But here again the problem remains that in Tool-Options-OpenOffice Base-Database-New section there is no option to choose ODBC. It is only asking for Database file name and Registered name.
 
Old 04-04-2007, 01:58 PM   #5
Conficio
LQ Newbie
 
Registered: Mar 2004
Location: Greater Boston, MA
Distribution: SuSE 9.3, SuSE 10.0
Posts: 23

Rep: Reputation: 15
ODBC is a Windows only technology as is Access

I think you are out of luck here. ODBC is as far as I know a windows only technology. If you try to get access to an MS Access database, you could try to run OOo under the Windows emulator WINE.

Or you can try drivers like these
http://www.easysoft.com/products/dat...FSEtEAodMwOtbQ and http://www.unixodbc.org/
 
Old 04-05-2007, 06:02 AM   #6
arindom
Member
 
Registered: Nov 2006
Location: India
Distribution: Ubuntu 11.04
Posts: 165

Original Poster
Rep: Reputation: 30
Thanks for your suggestions. I will check them surely.

I had to use Windows this time to get the job done. In the meantime I found OO has released 2.2, in which they have added some more features in Base. So I will try my luck with OO 2.2 first. Thanks again for the help.
 
  


Reply

Tags
base, linux, odbc, openoffice.org, wine


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Office 2.0.1 Base Import DBF CharSet ? k.king Linux - Software 0 01-19-2006 03:59 PM
Open Office 2.0.1 Base Import secured MDB k.king Linux - Software 0 01-19-2006 03:52 PM
Open Office BASE Bremsstrahlung Linux - Software 1 09-23-2005 08:19 PM
Unable to Access urpmi data base dolphans1 Mandriva 4 07-08-2005 05:55 AM
I need 'su' access in OpenOffice to open NTFS files penguin_powered Linux - Newbie 1 10-31-2004 04:54 PM


All times are GMT -5. The time now is 07:45 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration