Then can export the data as tab delimitted, csv, Excel... from FileMaker 6.
One of those options should work as a format from which you can import into SQL server.
I am stuck on the very first step - how to connect to and get data out of FileMaker 6.
No driver, no instruction
Do you have FileMaker 6 so that you can open the file? No driver should be needed. You can open the file and choose export from the File menu if you have Filemaker.
If you do not have Filemaker 6, you can download a free trial copy of Filemaker 11 and use it to open/convert the file, then export it into a compatible file format.
Hi, thanks, we are closer.
This FileMaker 6 is still a live system on another server. I don't want to interrupt it.
I want to use FileMaker 6 as an external data source, and create a daily ETL process to extract data from FileMaker 6 into SQL server for reporting purpose.
Using Filemaker 11 to open/convert the file, is only a manually one time work.
Hi, all and Phil
I installed FileMaker Pro 6 and FileMaker Pro 11 trial.
I can open the .fp5 files and see the data through the fm pro 6. And I can convert the fp.5 data files to fp.7 with fm pro 11, and see the data as well.
Now I am stuck on creating an odbc data source in Windows XP/2003 after installing the odbc driver found in fm 11 folder. I don't know how to fill up the Host and Database fields, to connect the fp7 files. I only see a new driver FileMaker ODBC.
Do I need to install some kind of service software to host the data, or expose a port for exteral access?
Thanks a lot
By the way, the message I get is "There was a problem connecting to the host."
Check your in box.