Apple Recognized User Group  MacAsia 

Go Back   PinoyMac.org > Software > iApps

Reply
Thread Tools Search this Thread Display Modes
Unread 04-04-2004, 08:11 AM   #1
maitani
Regular Member
Mac LC575
 
maitani's Avatar
 
Join Date: Aug 2003
Location: Las Piņas
Posts: 144
Thanks: 0
Thanked 0 Times in 0 Posts
Convert Access .mdb file to FileMaker Pro

I have a large (~25MB) MS Access database file (.mdb) that I wish to convert to filemaker pro 5 format. Please don't ask me to go back to Access and save it from there using a Filemaker readable format. This option will not work for me, I need a mac application that can do it. Your suggestions will be most appreciated.
__________________


maitani is offline   Reply With Quote
Unread 04-06-2004, 10:04 PM   #2
wpalomine
Moderator
eMac
 
wpalomine's Avatar
 
Join Date: Aug 2003
Location: NJ
Posts: 1,560
Thanks: 0
Thanked 12 Times in 9 Posts
bump
__________________
40.787368 -74.319046
wpalomine is offline   Reply With Quote
Unread 04-06-2004, 11:48 PM   #3
geecube
Moderator
iMac G5
 
geecube's Avatar
 
Join Date: Aug 2003
Location: Phoenix AZ
Posts: 3,746
Thanks: 0
Thanked 2 Times in 1 Post
Send a message via AIM to geecube Send a message via Yahoo to geecube
Re: Convert Access .mdb file to FileMaker Pro

Quote:
Originally Posted by maitani
I have a large (~25MB) MS Access database file (.mdb) that I wish to convert to filemaker pro 5 format. Please don't ask me to go back to Access and save it from there using a Filemaker readable format. This option will not work for me, I need a mac application that can do it. Your suggestions will be most appreciated.


Sorry maitani for the delayed response....Your post got buried with all the other ones.



Well, with that constraint that you put, I'm afraid that there's nothing we can do to make it readable from the Mac side. In its current raw format that .mdb file contains some Access proprietary garbage that you can't just filter. Although MS Access and Filemaker Pro are BOTH relational databases, they present data differently in their own proprietary format(s).



If you haven't put that constraint, you could easily export that MS Access file in Excel format (.xls) - PC side and import it later in FM Pro - Mac side. Also, even if you don't have Access - there are PC utilities that can convert that .mdb file into FM Pro readable format. :idea: But then, since those are NOT valid options - I'm running out of ideas.... :roll:



Good luck,

GeeCube :shock:
geecube is offline   Reply With Quote
Unread 04-07-2004, 01:44 AM   #4
ginoledesma
Regular Member
iMac G5
 
ginoledesma's Avatar
 
Join Date: Aug 2003
Location: Cupertino, CA
Posts: 2,218
Thanks: 0
Thanked 10 Times in 10 Posts
Send a message via ICQ to ginoledesma Send a message via AIM to ginoledesma Send a message via Yahoo to ginoledesma
Unfortunately, short of running MS Access on your Mac via VPC, I don't see how a Mac can open an mdb file natively, or even just to extract the data. If the MS Access database is live on the network, it may be possible to extract the data via ODBC, but the fastest way would be what you and Geecube first mentioned: go to the MS Access Database and export the data as Excel.
ginoledesma is offline   Reply With Quote
Unread 04-07-2004, 06:10 PM   #5
butchm
Junior Member
128K Mac
 
Join Date: Feb 2004
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Hi Maitani,



You have some more options:



1. Send the file to someone with MS Access so he can send the converted file to you.



2. If you have a PC with Access and FileMaker Pro, you can import the MDB file directly from the PC version of FileMaker Pro. Note that you need to have Access installed for this to work, but you don't necessarily have to run Access.



3. If you don't have a PC, you should be able to run do #2 under Virtual PC.



Hope this helps.



butchm
butchm is offline   Reply With Quote
Unread 04-07-2004, 11:18 PM   #6
geecube
Moderator
iMac G5
 
geecube's Avatar
 
Join Date: Aug 2003
Location: Phoenix AZ
Posts: 3,746
Thanks: 0
Thanked 2 Times in 1 Post
Send a message via AIM to geecube Send a message via Yahoo to geecube
You've Got A Friend...

Quote:
Originally Posted by butchm
1. Send the file to someone with MS Access so he can send the converted file to you.
Great suggestions... :idea: BTW, butchm, welcome to pinoymac.org - feel free to browse our forums and participate in our discussions..



GeeCube :shock:
geecube is offline   Reply With Quote
Unread 04-08-2004, 12:23 AM   #7
butchm
Junior Member
128K Mac
 
Join Date: Feb 2004
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
thanks, geecube! if anyone has filemaker pro related questions, i'll do my best to help.
butchm is offline   Reply With Quote
Unread 04-09-2004, 10:57 AM   #8
maitani
Regular Member
Mac LC575
 
maitani's Avatar
 
Join Date: Aug 2003
Location: Las Piņas
Posts: 144
Thanks: 0
Thanked 0 Times in 0 Posts
Thanks for all your sugggestions. I will try butchm's #2 option next week in the office. The export to xls hasn't worked for me because the database has over 500 fields.
__________________


maitani is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
New convert here. Firipinjin Newbie 19 10-13-2006 04:12 PM
Need help to convert wmv file to avi format Yakee09 iMedia 2 06-06-2005 12:45 PM
Can I convert an ITMS-purchased file to AIFF? Jughead iApps 6 11-09-2004 06:08 PM
How do I convert ogg to mp3? McArenas The Panic Room 8 08-30-2004 12:22 PM
convert dvd to .mov Anonymous The Panic Room 0 04-17-2004 11:38 PM


All times are GMT +8. The time now is 10:11 PM.


Powered by vBulletin® Version 3.7.5
Copyright ©2000 - 2014, vBulletin Solutions, Inc.