How to export Filemaker Pro 11 data to SQL Server?
Posted on 2010-09-06
I'm having all sorts of trouble porting a Filemaker 11 Pro database into SQL Server.
I first tried exporting a table into XLS format, but the resulting xls file would not load into a SQL table because it stated the column length was too great (even though the target column was defined as ntext which shoudl have allowed any length, and no excel column was more than a few hundred bytes anyway).
Next I tried writing an ASP script that read in an XLS spreadsheet into a recordset, but after the first row it again broke with a similar type message as soon as I executed a MoveNext on the recordset. I then modified my ASP scrript to simply movenext through the recordset without processing any of the rows, and again it croaked on the 2nd row, just by doing a simple movenext.
So I'm reaching out to the experts - surely there is a better way. can anyone advise me on how to get the FileMaker data out of FM Pro 11 and into SQL Server?