Newbies sp00ky Posted November 9, 2006 Newbies Posted November 9, 2006 Is it possible to import FMP 8.5 data into an excel spreadsheet on OS X? I can see and option to open an FMP 5 database but not fmp 8.5. Can this be done using odbc? If so, does someone have an example of how to set this up? I currently have a formatted excel spreadsheet and I would like to fill in parts of the spreadsheet with FMP data. Thanks
xoomaster Posted November 11, 2006 Posted November 11, 2006 As far as I can tell you, you can not open FMP files with Excel, unless you export the file into different formats first. Now of course FMP can import Excel files qiet nicely and quickly.
T-Square Posted November 14, 2006 Posted November 14, 2006 According to http://www.actualtechnologies.com/readme.php: "Starting with OS X 10.2, Apple has included ODBC support in the operating system in the form of ODBC libraries and an ODBC Administrator application (found in the Utilities folder). The libraries themselves work fine. " So, you should be able to create an ODBC resource that links to your FM database, and then use that in Excel. Apple refers you to http://www.iodbc.org/ for further assistance. David
Recommended Posts
This topic is 6585 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