Annie Courchesne, CMA
accma at sympatico.ca
Sat Apr 30 13:32:15 CDT 2005
Chris, Thanks for the info, I will try this with the demo version of file marker pro. Annie -----Message d'origine----- De : accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] De la part de Chris Mackin Envoyé : 30 avril 2005 13:25 À : Access Developers discussion and problem solving Objet : RE: [AccessD] Files maker pro and Access You can link to FileMaker Pro via ODBC that comes with FileMaker Pro. It is very frustrating and FMP is a piece of s*** application, but I've done it. One key pitfall, and there are many, is that FMP must have the file open that you are connecting to, otherwise the ODBC connection will fail. -Chris Mackin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Annie Courchesne, CMA Sent: Friday, April 29, 2005 8:25 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Files maker pro and Access Thanks for the info. I will download the demo and do some further testing. Annie -----Message d'origine----- De : accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] De la part de Stuart McLachlan Envoyé : 27 avril 2005 21:55 À : Access Developers discussion and problem solving Objet : RE: [AccessD] Files maker pro and Access On 27 Apr 2005 at 20:18, Liz Doering wrote: > Annie, > > I have found that FileMaker Pro can export to .xls or .dbf, but it isn't > itself a format that Access can link to. So your import will have to be > a two step process, one an export from within FileMaker Pro, then a > separate import into Access. Your best hope will be to get some > familiarity with FileMaker Pro: they have a 30-day free trial at > https://www.filemaker.com/downloads/trial_download.html > Filemaker Pro claims to allow you to access it's data from other applications using ODBC, but there is very little detail on their website. I suspect the ODBC driver comes as part of their Development Package. You could also try the Fielmaker Pro ODBC driver at http://www.versiontracker.com/dyn/moreinfo/macos/1602 -- Stuart -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com