Re: Parameter Driven Query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

ADO.NET is for the dotnet languages like C# etc. so you want ADO.
Plenty of good tutorials on the web to get started. Just Google on
something like ADO tutorial.

RBS

On 7 Jan, 14:51, mr tom <mr-tom at mr-tom.co.uk.(donotspam)> wrote:
Just a couple of quick questions:
What's the difference between ADO and ADO.NET? - Which do I need for Excel?
Where can I learn (idiot level) about this?  Is there a good book or website?

Cheers.



"RB Smissaert" wrote:
There really isn't that much to  learn there only a few objects, methods and
properties. Then there always is the public.data.ado NG to ask if you get
stuck. MS Query is fine for a quick query from the Excel interface, but if
you
get into anything that goes a bit further you are better of with ADO.

RBS

"mr tom" <mr-tom at mr-tom.co.uk.(donotspam)> wrote in message
news:27AB4E05-5632-41C8-9ECA-782B401C1F2D@xxxxxxxxxxxxxxxx
It probably would be better, but I'm still getting to grips with VBA and
SQL.
;)

I'm a project manager (not an IT one) rather than a techie, although I do
as
much techie stuff as I can as I don't like to be helpless...

Cheers.

"RB Smissaert" wrote:

Better to move away from MS Query and code with ADO where you have
parameterized queries and a lot of other useful options.

RBS

"mr tom" <mr-tom at mr-tom.co.uk.(donotspam)> wrote in message
news:E6215ABB-48A8-4D0B-8F24-D0872FDA00E7@xxxxxxxxxxxxxxxx
Hi,

I'm used to using MS Query to return data to Excel, but there's a whole
stack of queries that I run each month (literally, dozens) where the
date
range needs to be changed.

I'm wondering whether I could put the chosen date ranges into an excel
spreadsheet, maybe in the format:

Col 1   Col 2   Col 3        Col 4
sheet  query  start date  end date

...and use VBA to modify the SQL for me.

Alternatively, can the SQL itself be written to request a parameter
from a
particular location?

Any ideas?  This could be a massive time saver!

Cheers,

Tom.- Hide quoted text -

- Show quoted text -

.

Relevant Pages

  • Re: UNION Query problem
    ... >> automation error when trying to get a recordset based on it. ... I'm not sure if ADO supports ... query in another part of the program using ADO, ... parameterized queries using ADO as well. ...
    (microsoft.public.vb.general.discussion)
  • Re: Connecting to an Access Database in Delphi 2006
    ... You can use a dataSource component and a ADO Table to connect to the ... access.mdb database.Go to delphi.about.com there is lots of tutorials there. ... Paul ...
    (borland.public.delphi.database.ado)
  • tutorials and more
    ... I must develope a ADO - Project in ATL 7.0. ... Therefor I look for all stuff ... Who knows tutorials or sites which can help me getting a better ...
    (microsoft.public.data.ado)
  • Access SQL Server Express over the Internet
    ... Does anyone know of any tutorials to point me in the right direction on how ... to setup SQL Server Express so I can access it over the Internet using ADO? ...
    (borland.public.delphi.database.ado)
  • Re: using Database in EXCEL ?
    ... using ado with access db in excel step by step ... i cant find any normal full tutorials, only examples, ...
    (microsoft.public.excel.programming)