ADO

[eddyb2]

Hi,

Does anyone have any experience of using ADO with FileMaker?

The idea is to create a button in an Excel spreadsheet which a user will click to update the database with information in that spreadsheet.

I know FileMaker accepts ADO commands through the ODBC Driver but have no experience of this.

Does anyone have any pointers or any links to tutorials etc

Many thanks for any help.

Ed

Edited September 4, 2006 by Guest

[Wim Decorte]

What exactly is your struggle with ADO? ADO works through an ODBC connection so there is very little specific FM stuff that is required. It works just like any other ADO connection.

Once you have the connection you can use the SQL syntax to request data and get a recordset just like from any other ODBC compliant database. That's why you won't find any FM specific info on this.

What doesn't work for you?

[eddyb2]

I have never used ADO before, I have just been told that this will work.

I downloaded ADO but not sure where to start on it, I can't seme to find any beginner guides on using this to communicate between Excel and FM/any other DB.

Many thanks

[Wim Decorte]

I'm sure that if you do a google on "ADO FileMaker" you'll get some hits :)