Refreshing data in Excel from SQL

[Paul D]

I have imported data from SQL, and I have added some
columns to the spreadsheet. When I try to re-fresh the
spreadsheet, it does not import any current or new data.

** however when I create a new tab, and import again, the
data is current.

I need to create the same calculations in different tabs
(worksheets)and use filtering by date and by client type,
to produce a usage report.
..

 

[Gerrit-Jan Linker]

You may want to try SQL*XL.

SQL*XL is an addin that allows full database access from Excel. You
can query, insert or update queried data.

SQL*XL has a requery button. It requeries all select statements in
batch.

If you would like to have a look at SQL*XL please proceed to
www.oraxcel.com

Best regards,

Gerrit-Jan Linker
Linker IT Consulting Limited
www.oraxcel.com
Author of SQL*XL

 

[Jamie Collins]

(e-mail address removed) (Gerrit-Jan Linker) wrote ...

You may want to try an addin that allows full database access from Excel.

Where were you three weeks ago?! That guy could really have really
benefited from your shameless advert ...oops, I meant to say,
'invaluable advice'.

Jamie.

--