Solved

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

Posted on 2003-11-12
4
5,923 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Windows 2003 SBS network periodically hangs 10 32
PDF In Filemaker GO 3 1,058
Filemaker Server 14 - Webdirect NAT access 8 85
Need to burn a .dmg file that is 5.965GB in size 4 64
Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
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…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

937 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

Need Help in Real-Time?

Connect with top rated Experts

4 Experts available now in Live!

Get 1:1 Help Now