January 24, 200125 yr Newbies 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?:? ------------------
January 24, 200125 yr 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.
January 24, 200125 yr 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 =-=-=-=-=-=-=-=-=-=-=-=-=
January 24, 200125 yr Author Newbies 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!!
January 30, 200125 yr Newbies 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.
February 4, 200125 yr Yes, FMP 4.1 is import-only, FMP 5 allows both importing and exporting. Works fine for me. John
Create an account or sign in to comment