Importing Access file into FM5 Macintosh

[bclead]

I recently bought and installed Filemaker 5 on my Macintosh Computer. I have a file created in Microsoft Access (.mdb). I am kind of a newby and tried just opening with Filemaker using the open command. It converted the file into a bunc of gibberish. I keeny aware that I am not doing it right?! How do you open an Microsoft Access file in Filemaker?:?

------------------

[BobWeaver]

Do you have access to ..er Access? If so, open the file in Access, and save it as one of dbf, dif, sylk, tab or csv (in order of preference). I'm not sure exactly which of these formats Access can export to. Filemaker should then be able to read or import the file.

[Kurt Knippel]

quote:

---

Originally posted by BobWeaver:

Do you have access to ..er Access? If so, open the file in Access, and save it as one of dbf, dif, sylk, tab or csv (in order of preference). I'm not sure exactly which of these formats Access can export to. Filemaker should then be able to read or import the file.

---

You could also setup an ODBC connection to the Access DB.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

[bclead]

quote:

---

Originally posted by captkurt:

You could also setup an ODBC connection to the Access DB.

---

I am not familiar with how to use ODBC yet! Thanks!!

[rodneyo]

quote:

---

Originally posted by captkurt:

You could also setup an ODBC connection to the Access DB.

---

I've been looking for ODBC help! Does FMPro come with ODBC drivers? I need to connect to our shipping system, which is basically an Access 2000 DB.

[JW]

Yes,

FMP 4.1 is import-only, FMP 5 allows both importing and exporting.

Works fine for me.

John