Re: How to export data from SQL Server to Excel using VBScript?

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Tue, 6 Mar 2007 05:19:05 -0800, Andrew <Andrew@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

¤ How can I use operator 'WHERE' in your script? For example:
¤
¤ SELECT [order_number] AS [Order Number] FROM [Orders] WHERE [order_number] =
¤ '123456'

Just add the WHERE clause to the end of the SQL statement.


Paul
~~~~
Microsoft MVP (Visual Basic)
.

Relevant Pages

  • Re: Using Access 2000 db with VB 6
    ... Post the SQL statement and maybe we can see something wrong with it... ... Chris Hanscom - Microsoft MVP ... > database: ... > How do I view the From clause to fix it? ...
    (microsoft.public.vb.database.ado)
  • Re: moving menus
    ... Unfortunately this solution suffers from the same "stuttering" on the ... Microsoft MVP - Frontpage. ... > Absolutely positioned elements outside of div.content will be ... > doesn't stutter on the screen as the script based examples I ...
    (microsoft.public.frontpage.client)
  • Re: Licensing problem
    ... I think it is safe to assume that they will patch it. ... I ran the script, and it worked fine. ... Microsoft MVP ... not an academic volume license. ...
    (microsoft.public.mac.office)
  • Re: scripting references Re: sharepoint + unix
    ... > an established script out there that works around the Microsoft shared ... >> Microsoft MVP - FrontPage ... >> | Moving the entire site to a microsoft server is not easy nor feasible- ...
    (microsoft.public.frontpage.programming)
  • RE: Queries returning with missing info (plus asks query question
    ... Let’s start with the simple query first. ... are aggregate functions, but not reserved words. ... what is at the front of the SQL statement. ... Parameter clause at the top. ...
    (microsoft.public.access.queries)