+ Reply to Thread
Results 1 to 3 of 3

query excel from vbscript

  1. #1
    Registered User
    Join Date
    11-30-2004
    Location
    Israel
    Posts
    4

    query excel from vbscript

    i succed in query number of rows in excel file, but i can't make a query on certin column, or get the value of certin column ,
    this is the code i have
    Please Login or Register  to view this content.
    what do i need to change to make a group by on certin columns, or just to make a select on certin columns
    thanks
    Peleg
    Israel the best place to live in - after heaven (but no one wants to go there so fast - )

    http://www.networked-toys.com

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,016

    Re: query excel from vbscript

    If you don't have column headers, you will need to use F1, F2 etc to refer to the fields you want according to their position.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Registered User
    Join Date
    11-30-2004
    Location
    Israel
    Posts
    4

    Re: query excel from vbscript

    thnaks alot
    that what i was looking for, the default alias name of the column which starts with "F"

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1