Export FMP Database to Access

[CBlackmo]

I am having a problem exporting a FMP database to MS Access. I selected the main table and all related tables. The related tables include multiple records for one person. I tried grouping and not grouping the fields too. I saved the file as a .dbf

The result in Access shows the field names and then a bunch of rows with #Deleted on each column (I'm assuming these are the other records included in the related tables). Any ideas how I get all of the records?

 

[philhege]

Do you have unique keys in the exported tables? Did you try to import them into Access instead of linking to them?

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.

 

[CBlackmo]

Key field as in creation date? When I exported, I clicked on file export and exported as a .dbf. Any help is appreciated. thanks

 

[philhege]

Try using the import function (File -> Get External Data -> Import) in Access on the DBFs. You should be prompted to provide a unique key field (or combination of fields) before Access can import or view the data properly.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.

 

[CBlackmo]

Thanks, I figured it out. I had to import each FMP table separtely into Access.