Excel ODBC FMSA

[eddyb2]

Hi all,

I have a database running on FMS8Adv ODBC sharing is enabled

I have the ODBC client running on my machine

I can open up an ODBC cnnection between the 2 no problem.

So far so good.

What I'm after help on in the next step...

I have an excel spreadsheet storing quite a lot of information, what I want to do is add a button to Excel, which when pressed send information from certain cells to the hosted FileMaker database.

I know I need to use SQL commands to do this but not sure where to start.

has anyone any experience with this who could give me a few pointers, or perhaps point me to a good tutorial?

many thanks

[Ben Goldstein]

http://www.rdg.ac.uk/ITS/info/training/notes/excel/query/

(not sure if this is what your asking for though..)

[eddyb2]

Hi Ben, thanks for your reply

This is similar to what I wasnt but unfortunately the wrong way round.

I want to be able to edit records in the database using the data in the spreadsheet, so an SQL command which is somehow activated from within the spreadsheet which will then use ODBC to edit the database on the server.

Hope this is a little clearer.

Many thanks again

[Wim Decorte]

The next step will involve writing VBA code in Excel to push data through the ODBC connection to FM. I don't think we can help you much with that, you're more likely to find help on an Excel VBA list for that. Start by doing a google search on "VBA Excel ODBC"...