Newbies jassf Posted May 6, 2004 Newbies Share Posted May 6, 2004 Is it possible to open/import an MS Access db into FMP? Many thanks... Link to comment Share on other sites More sharing options...
Vaughan Posted May 6, 2004 Share Posted May 6, 2004 Not open, no. Neither can it be converted to FMP in one step. The only option is to rebuild the Access file in FMP (fields, interface, scripts etc) then export/import the data across. Link to comment Share on other sites More sharing options...
Reed Posted May 6, 2004 Share Posted May 6, 2004 You have several choices... the two most obvious are: 1. export the access tables as text or excel tables etc, and import them into FMP 2. Set up the access database as an ODBC data source, and then use SQL to query the tables and import data into FMP VBA scripts and calculations will have to be recreated manually in FM along with forms and other layouts/reports. Link to comment Share on other sites More sharing options...
Ken Newell Posted May 18, 2004 Share Posted May 18, 2004 Take a look at http://www.fmpromigrator.com I have not used it but found this on the net and spoke to the developer about his products while look at migration tools. His tools can migrate between many different DB including Access and FM. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7304 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now