Importing Mcrosft Access Data into FM 5.5?

[Maxx]

Hello,

I need to get a mailing list file from Access 2000 (PC) into FileMaker 5.5 (Mac). One sugestion I got was to export the file as an Excel document then import that into FM.

Any better way?

Need all the help I can get!

Thanks,

-Maxx

[ronpalmer2000]

I haven't tried this with Access - however I do import and export to other applications by creating a mapped script in a compatable format.

I cannot imagine Access not having an import-export capability with comma or tab delimiters.

[Thom]

Have you tried ODBC?

[Steven H. Blackwell]

Export Access data to Excel spreadsheet. Drop spreadsheet onto FMP application icon. New database will be created automatically.

Old Advance Man

[anita hamis]

OAM is of course right but what if you want to import limited records in a certain sort order?

I think this is when ODBC comes in whereby you need to make sure that proper ODBC drivers are installed in your computer before you start the import process.

NB:with ODBC you can import directly from Filemaker by selecting ODBC data sources from files of type drop down list.

anita.

[rrrichie]

To export a subset just create a query in access2000. It has these cute little wizards.

Once the query is open, export that.

Greetings Ramon