stewboy
asked on
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).
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).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
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.
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.
Kinda goin backwards though. Access is messy.