Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Software - Troubleshooting and Discussion > Mac OS X > Accessing Access Databases on a Mac

Accessing Access Databases on a Mac
Thread Tools
ls -al
Mac Enthusiast
Join Date: Mar 2001
Status: Offline
Reply With Quote
Dec 14, 2003, 05:23 PM
 
I'm cross posting with the software forum due to the urgency of the issue. I hope one of you has enough PC experience to help...

I've acquired some legacy databases that are in Access .MDB format. I need to be able to import the data into my Mac. FM Pro does not import these files directly. Neither will Excel. How do I massage these files to bring them over to my Mac.

Quick help appreciated.
     
Arkham_c
Mac Elite
Join Date: Dec 2001
Location: Atlanta, GA, USA
Status: Offline
Reply With Quote
Dec 14, 2003, 06:59 PM
 
Originally posted by ls -al:
I'm cross posting with the software forum due to the urgency of the issue. I hope one of you has enough PC experience to help...

I've acquired some legacy databases that are in Access .MDB format. I need to be able to import the data into my Mac. FM Pro does not import these files directly. Neither will Excel. How do I massage these files to bring them over to my Mac.
There are numerous tools to convert MS Access databases to MySQL or PostgreSQL. I'd recommend using one of those.

http://www.cynergi.net/exportsql/

http://www.mysql.com/portal/software...s/index-3.html

Hope that helps.
Mac Pro 2x 2.66 GHz Dual core, Apple TV 160GB, two Windows XP PCs
     
   
Thread Tools
Forum Links
Forum 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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Top
Privacy Policy
All times are GMT -5. The time now is 06:15 PM.
All contents of these forums © 1995-2011 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.7 © 2000-2011, Jelsoft Enterprises Ltd., Content Relevant URLs by vBSEO 3.3.2