Results 1 to 7 of 7
We have a MS Access database setup at work but, I seriously want to use Ubuntu instead of Windows and in order to do this I need to be able ...
- 05-21-2008 #1Just Joined!
- Join Date
- May 2008
- Posts
- 15
MS access database conversion to .odb
We have a MS Access database setup at work but, I seriously want to use Ubuntu instead of Windows and in order to do this I need to be able to convert the Access database to .odb.
I followed instructions I found on another Linux forum but, it didn't work as Openoffice still opened the database in its' own word processor format within Base instead of showing me the database complete with its structure and entry forms that we use for entering details about jobs.
All I see is some characters at the top of a 'document like' application.
I have downloaded and installed Wine but, it does not show me the Access program when it scans my 'C' drive only my Windows directory and the Program Files directory which should contain the Microsoft Office directory but, does not.
Any ideas on these would be greatfully appreciated.
- 05-21-2008 #2Linux Guru
- Join Date
- Nov 2004
- Posts
- 6,110
How complex is the database? If it is simple enough you could export the tables to a flatfile like csv and import them into a new odb. That would give you the opportunity to start from scratch and avoid bringing legacy junk with you.
- 05-21-2008 #3Just Joined!
- Join Date
- May 2008
- Posts
- 15
MS database further
The database is quite complex. Lots of boxes to fill on a single form. What do you mean by legacy junk?
- 05-21-2008 #4Trusted Penguin
- Join Date
- Jul 2004
- Location
- Either at home or at work or down the pub
- Posts
- 2,287
Legacy Junk: Code that has been patched over time and become messy and unreadable.
Doesn't Base import from Access?If we hit that bullseye, the rest of the dominoes will fall like a house of cards. Checkmate! (Zapp Brannigan)
My new blog. It's probably not as good as I think it is.
- 05-21-2008 #5Linux Engineer
- Join Date
- May 2004
- Location
- Harrow, UK
- Posts
- 949
Originally Posted by elija 
No. I've tried that too. It's really silly because Writer imports from Word, Impress from Powerpoint and Calc from Excel. And Linux recognises .mdb files as jet engine databases: it's just Base that doesn't."I'm just a little old lady; don't try to dazzle me with jargon!"
- 05-21-2008 #6Trusted Penguin
- Join Date
- Jul 2004
- Location
- Either at home or at work or down the pub
- Posts
- 2,287
That does seem a strange omission! Maybe in the next release Originally Posted by hazel If we hit that bullseye, the rest of the dominoes will fall like a house of cards. Checkmate! (Zapp Brannigan)
My new blog. It's probably not as good as I think it is.
- 08-24-2009 #7Just Joined!
- Join Date
- Aug 2009
- Posts
- 0
Migrate MYSQL to Oracle database
I prefer a third party applpications for migrating my data, i use data loader when i was migrating MS SQL to Foxpro it work great, and it can migrate almost any database.
Download Free Find here : www(.)dbload(.)com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
