Exporting a record into a cell in Excel

[cdr-dev]

I was looking around for a way to have a field in my database to be able to export to a specific field in Excel.

IE: Field "Install Date", to export via script into an Excel Template(.xls) called. "TN Change Form", into cell "A7".

Any ideas how to make this work? Is this a SQL related question or can a special type of calculation make this work. Thanks in advance.

Chris

[Wim Decorte]

You can set up your Excel sheet to use FM as an ODBC data source and insert FM data into the cells you want, or you can use VBscript to talk to Excel and put the data where you want.

[cdr-dev]

Wim, Thanks for the insight. I was thinking ODBC might be a possibility, but what OLE DB Driver would I select from Excel? I have found a couple of ODBC drivers in searching. Which is the easiest to work with for this type of situation? Actual Technologies has a pretty slick interface for their driver but do not indicate if ODBC can pull out of Filemaker. They only mention the big dogs like MS SQL, Oracle, etc. Thanks!

[Wim Decorte]

You have to use FileMaker's driver, no other driver will work. The driver comes with FileMaker 8 Advanced and FMSA I believe.