Technical Discussion
  >> Apple Issues


Register (or login) on our website and you will not see this ad.


These posts have been archived and can no longer be replied to or modified.
  Print Thread
Standard User deleted
(deleted) Tue 09-Jun-09 23:37:36
Print Post

Convert access to csv without a pc or office!


[link to this post]
 
I have a few mdb files that need converting from access. Think they're an ancient works version rather than a latter office one. Openoffice doesn't like them. Neoffice neither. Tried openoffice 2.3 and 3.1. Latter on an intel mac on the off chance things might be different.... Found an online converter but they do the wrong way round.

I have crossover office so a freeware mdb to csv tool is a possibility. Don't want to have to pay anything as it is a favour and don't invisage having to do this again (famous last words)

An online coversion tool would be the easiest answer. Media convert is mostly video/image. Zamzar does csv to mdb but not the other way round. Their file utility also thinks the file is empty when it isn't too.

Any bright ideas on the easiest way to do this?
Standard User sjr
(fountain of knowledge) Wed 10-Jun-09 08:45:42
Print Post

Re: Convert access to csv without a pc or office!


[re: deleted] [link to this post]
 
I don't know if this is the easiest or quickest way of going about this but it should work. A combination of Oracle XE database and the Oracle SQL Developer tools (both free downloads from oracle.com) should do the job. Oracle SQL Developer has a migration wizard to migrate Access applications so if the mdb file is in Access format then that should get your data into tables in the Oracle database and you can then use export tools in Oracle XE or the SQL Developer tool to get the data into csv files.
The gotcha is that the XE database needs either Windows or a selection of Linuxes so you would need to run say Ubuntu in a VM to get the Oracle database running.
A bit of a faff but it should work as long as the mdb file is recognised as Access compatible.

Regards,
Steve
Standard User deleted
(deleted) Wed 10-Jun-09 11:26:19
Print Post

Re: Convert access to csv without a pc or office!


[re: sjr] [link to this post]
 
A bit of a faff is a slight understatement grin I'll exhaust other avenues before venturing into the world of virtual linuxes smile


Register (or login) on our website and you will not see this ad.

Standard User sjr
(fountain of knowledge) Wed 10-Jun-09 16:40:55
Print Post

Re: Convert access to csv without a pc or office!


[re: deleted] [link to this post]
 
Well if you do have to go down that route you can read all about migrating an Access database into Oracle on the Oracle site

Regards,
Steve
  Print Thread

Jump to