I NEED TO IMPORT A FMPRO7 FILE RECEIVED FROM CLIENT.

[Guest]

I can use excel or access. A second option is to convert the fmpro7 to a
text delimited or fixed field or db file.

Thanks

 

[tina]

well, you're not clear on what your question is. i have no experience with
fmpro7 files, so i would probably convert the file to a text file, either
delimited or fixed width, which can be imported into Access with good
control of the import process. to import, open the Access db, and click
File, Get External Data, Import from the menu bar.

hth

 

[John Vinson]

I can use excel or access. A second option is to convert the fmpro7 to a
text delimited or fixed field or db file.

Thanks

FileMaker provides an ODBC driver (see their website); you can use
File... Get External Data... Link to link to your FMP table using this
driver. A text or dBase file can be imported as well, using File...
Get External Data... Import.

Note that FMP tables very often contain "non-normalized" features such
as calculated fields or "lookup" fields; these will often need to be
redesigned in Access.

John W. Vinson[MVP]