import FileMaker Pro v 3.0 (PowerMac) to MS Access 2000 (windows)

I need to import FileMaker Pro 3.0 tables (PowerMac) into MS Access 2000 (windows).

I had help from a Mac-savvy IT guy who got the tables into DBF files, but they weren't recognized by Access for import.

Someone please tell me there's a magic wand out there that will make this easy!

The abacus, er, PowerMac the db curently resides on is OS v 8.1 ( I think that's an OS version. I'm not a Mac guy).
stewboyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mariano_PetersonCommented:
Open all the files using the master password on the abacus.
(tables are represented as files in FileMaker)
For each file,
...menu: "Records > Show All Records" (if its dimmed that means all records are already shown, which is good)
...menu: "File > Export Records..."
...In the dialog, under "Save as Type:", select an appropriate type (tab, csv).
...In the dialog, under "File name:", enter a name for the export filename.
...(since you'll be doing this on a Mac, be sure to explicitly add a .csv or .tab or .xml suffix to the filename)
...In the next dialog, click "Move All", then click Export

This will export all the data from FileMaker into a format that you can import in Access.
Of course, you'll have to create the table structure in Access.  I'm not sure about how to automatically create the create the table structure in Access.

Hopefully the previous DBA there left you an ERD to go from.  Otherwise, you can print the field definitions for each file (File > Print, then choose Print: Field definitions).  Also, you can view the relationships in each file by going to File > Define > Relationships.  Note that many relationships in FileMaker are created to support UI functionality, and are not necessarily part of the structure.

Good luck!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
weedCommented:
http://www.versiontracker.com/dyn/moreinfo/macosx/18656

Kinda goin backwards though. Access is messy.
0
lesouefCommented:
If you choose to export .tab files, be care with the ascii character set which is generated by filemaker mac, it is not ISO compliant, and some of the extended characters (> 127) will be wrong on PC.
Though this is mainly a non-english concern, better use filemaker on a PC to the tab export, or use BBedit to convert to UTF-8. Search and replace will also work, but might be tedious depending on amount of files you need to recuperate.
0
rogierCommented:
The DBF files or tab-delimited files that Filmaker can export may not be recognized by Access, but they will be by Microsoft Excel on the wintel machine.

As I suppose from there everything is familiar to you, I'm sure you'll fix the last step to get all the data from Excel into Access.

Show All Records or shortcut Apple-J
Export records (file menu)
Name properly, move all fields

Excel will open a tab delimited file. It will just ask you if the first record contains the headers of the columns, which is not too much to worry about.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.