question on Excel and SQL

Morning all.
I'm now crossing in to completely new territory here so please bear with me,
and if this should be posted elsewhere, please let me know. Or if I've
misstated something, please let me know......

I've been finding instances of our data being incomplete due to laziness on
my part because we have so many different sources of data in our offices and
how involved checking all those sources becomes. Yea, I know..... shoot me
later.

How would I go about having VBA code look on our SQL database to check the
data and do a comparison to match everything up. Then, if data is missing in
our excel files, either import it or set a flagging routine to let me know
that there's data missing?

As I said, this is going much farther than I've done in programming before,
so please be patient with me.
I know that the programmers who do our updates on SQL server are using VB
when updates, and modifications are performed. My HOPE is that I can use VBA
to accomplish my goal, and not cross into another language-- our IT dept
won't let me "play" with and language that makes changes to anything other
than Office Products. Which I'm sure you can all appreciate.

Thank you.
Best.



.

Relevant Pages

  • Re: Publishing Open Source Stuff
    ... >Programming complete applications to a high standard is tiring, ... >updates, web page update, installer building, uploading - just as much work ... >as commercial code releases: otherwise its rubbish. ... Yep I know that feeling from when the TP7 apps made the rounds. ...
    (borland.public.delphi.non-technical)
  • Re: OT: Microsoft sucks, part 953
    ... not just programming, ... Actually, given the amount of bugs in those very critical updates, I'd say it's more risky to install them rather than not. ... It's not that WGA mimics as component update, but it's you can't have component update if you refuse WGA. ...
    (misc.consumers)
  • Re: Update Sql Server 2000 database from the HP3000
    ... collects those updates via ODBC every 10 or so seconds. ... essentially update the SQL database at the same time as the main ... Authorised and regulated by the Financial Services Authority. ...
    (comp.sys.hp.mpe)
  • Auto Install for MIDlets
    ... I have limited Java experience and have not done any J2ME or J2SE ... We have a J2ME application currently running on Nextel phones. ... carriers and 2) be able to "push" application updates to the ... J2ME or J2SE programming before, so of course I was the perfect choice ...
    (comp.lang.java.help)
  • Asynchronous access problem
    ... I have a form that queries a SQL database and updates an Access table through ... This procedure is run on demand. ... I run an update query to clear out the data in the table that my ...
    (microsoft.public.access.formscoding)
Loading