Link to home
Start Free TrialLog in
Avatar of rascal
rascalFlag for United States of America

asked on

How to export Filemaker Pro 11 data to SQL Server?

Hi Experts,
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?

Many thanks!
ASKER CERTIFIED SOLUTION
Avatar of North2Alaska
North2Alaska
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rascal

ASKER

I can create a DSN and use odBC, but where is the option to do so in FileMaker? In the EXPORT option I am only presented with options to save to xls, csv, etc.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rascal

ASKER

Thank you both, I ended up exporting to xls so I could get the column names, then exported again to csv so I could get the data, then imported into SQL and had it auto-generate the table, then wrote a script to perform the necessary mappings and conversions to get it into its final data format. whew.