Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 6855 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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.

Posted

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!

Posted

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

This topic is 6855 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.