Currently I am trying to link my excel spreadsheet with a SQL database. what
i want setup is so that the cell is linked to a specific cell in the database
and is continually updated. is this possible.. if not how do i create a
macros button to allow me to refresh when required. Thankyou for your
assistance.

perhaps using Data=>External Data and create a query in the worksheet using
ODBC. Use an SQL query that returns the single value you want.

The properties of the querytable can be set to control refreshing although I
am not sure about continuously - but periodically as I recall. You probably
want to reject the option to allow a backgroundquery.


--
Regards,
Tom Ogilvy



"Spudanator" <(E-Mail Removed)> wrote in message
news:3AC83E24-6F0D-4B6B-8546-(E-Mail Removed)...
> Currently I am trying to link my excel spreadsheet with a SQL database.
> what
> i want setup is so that the cell is linked to a specific cell in the
> database
> and is continually updated. is this possible.. if not how do i create a
> macros button to allow me to refresh when required. Thankyou for your
> assistance.

Your best bet is simply to use the "get external data" feature under
the "data" menu item. Record your actiions via the macro tool while
you go through the motions to get your external data.

ONce you've completed it, just edit the code you just recorded to tweak
it for any variables you want etc.

You can update it / refresh it whenever you want or even just set it up
to auto update.

Regards,
Jamie
Spudanator wrote:
> Currently I am trying to link my excel spreadsheet with a SQL database. what
> i want setup is so that the cell is linked to a specific cell in the database
> and is continually updated. is this possible.. if not how do i create a
> macros button to allow me to refresh when required. Thankyou for your
> assistance.

Sorry for the late reply but i figured out how to do it by importing the
whole table into the document. few questions

Is there a reason why i would want to reject the option to allow for
background query. each time i try and use an SQL query to return a value. all
that seems to do is write the SQL query on the spreadsheet. i have done it a
different way and got the whole table to be output on a seperate worksheet if
its possible to do it another way i would alway like to know just for my own
knowledge. Finally once this is done how can i then send some new data back
to the SQL data base..
"Tom Ogilvy" wrote:

> perhaps using Data=>External Data and create a query in the worksheet using
> ODBC. Use an SQL query that returns the single value you want.
>
> The properties of the querytable can be set to control refreshing although I
> am not sure about continuously - but periodically as I recall. You probably
> want to reject the option to allow a backgroundquery.
>
>
> --
> Regards,
> Tom Ogilvy
>
>
>
> "Spudanator" <(E-Mail Removed)> wrote in message
> news:3AC83E24-6F0D-4B6B-8546-(E-Mail Removed)...
> > Currently I am trying to link my excel spreadsheet with a SQL database.
> > what
> > i want setup is so that the cell is linked to a specific cell in the
> > database
> > and is continually updated. is this possible.. if not how do i create a
> > macros button to allow me to refresh when required. Thankyou for your
> > assistance.
>
>
>