From the beginning

[WC Howard]

Greetings!

I have an SQL file that I'd like to import into an FMPRo database. It was generated by another local program.

I tried to download Actual's drivers but I cannot make connection to this file. I have a feeling that I have to set up a local database host (server) on my Mac (right?). Can anyone point me in the right direction on how to do this?

:o

[Reed]

How to do that would depend on what type of database file it is. What program was used to create the file? Can that program act as an ODBC host?

[WC Howard]

No. The program is MailSteward, which is supposed to be software based upon SQL, but I didn't see anything that said it would be a host... Being that it is a database program itself I would leave the files in there but I need to make them accessible (FM).

Is there anything like open source software that would allow me to host the file locally long enough to export (or import into FM)?

[Reed]

On the mailsteward website, it says the file can be imported into MySQL. So you could install that on your computer and run that as the host.

It looks like they have a standard installer on the mysql website now, so you will be able to install it without much hassle. Once installed, you just need an ODBC driver to allow FMP to talk to mysql. The driver from actual technologies is the most common one. If you check out the webinar on FMP MySQL integration on the filemaker.com website, you'll see that using MySQL data in filemaker is about to get much simpler.