Solved

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

Posted on 2003-11-12
4
5,930 Views
Last Modified: 2007-12-19
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).
0
Comment
Question by:stewboy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 3

Accepted Solution

by:
Mariano_Peterson earned 125 total points
ID: 9734551
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
 
LVL 30

Expert Comment

by:weed
ID: 9736991
http://www.versiontracker.com/dyn/moreinfo/macosx/18656

Kinda goin backwards though. Access is messy.
0
 
LVL 28

Expert Comment

by:lesouef
ID: 9754515
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
 
LVL 4

Expert Comment

by:rogier
ID: 9873773
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

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question