September 4, 200619 yr 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, 200619 yr by Guest
September 6, 200619 yr 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?
September 7, 200619 yr Author 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
Create an account or sign in to comment