Good guide for Excel/Query/SQL
Hi All
I'm trying to get far better control when creating Excel/VBA reporting of
SQL data.
I don't want the user messing with query, so I use the Macros/VBA part to
create the querying in the background. Only problem is that at present all
I can do with this is just retrieve one 'chunk' of data I don't seem to have
the flexibility like I can with ASP.
Can anybody give me pointers on how I can get the same versatility in Excel.
Thanks
Laphan
|