from Access/Excel to FILEMAKER

[Ricardo]

Hi All,

is there a simple way of exporting info from MS Access or Excel files to a Filmaker pro database?

this will be done on a daily basis.

thanks,

ricardo.

[cjaeger]

a) Ms Access -> Excel-> Filemaker, no direct conversion, see below

: MsExcel->FileMaker

rename the file(s) to be imported to a defined name, put them into a folder named import somewhere in your solution folder, then script the import.

[Vaughan]

For Access, you need to export the data into a suitable file (tab or comma delimited for instance) then import this file into FMP.

[Ricardo]

Vaughan said:

For Access, you need to export the data into a suitable file (tab or comma delimited for instance) then import this file into FMP.

thanks Vaughan. is it possible to export the info automatically from Access or excel. so that all the user needs to do is import the info from the FM database via a scripted button?

[Vaughan]

Prolly. But I only know FMP.

[_ian]

By far the best way to appraoch this is to simply import from Access into FileMaker via ODBC. The process can be scripted so it will run when the user clicks a button...

Ian