dcsimg
Results 1 to 4 of 4

Thread: [RESOLVED] Command text definitions for ADO to Excel

  1. #1

    Thread Starter
    Fanatic Member cory_jackson's Avatar
    Join Date
    Dec 2011
    Location
    Fallbrook, California
    Posts
    904

    Resolved [RESOLVED] Command text definitions for ADO to Excel

    I have the functional command text "SELECT * From [Main$]" but it did not function until I added the dollar sign and I don't understand why. I would like to know more about the syntax for command strings for Excel but I can't find any on the MSDN. If someone could point me to where this is detailed I would greatly appreciate it.

  2. #2
    Hyperactive Member mbutler755's Avatar
    Join Date
    May 2008
    Location
    Peoria, AZ
    Posts
    417

    Re: Command text definitions for ADO to Excel

    The $ designates a tab.
    Regards,

    Matt Butler, MBA, BSIT/SE, MCBP
    Owner, Intense IT, LLC
    Find us on Facebook
    Follow us on Twitter
    Link up on LinkedIn
    mb (at) i2t.us

    CODE BANK SUBMISSIONS: Converting Images to Base64 and Back Again

  3. #3
    Hyperactive Member mbutler755's Avatar
    Join Date
    May 2008
    Location
    Peoria, AZ
    Posts
    417

    Re: Command text definitions for ADO to Excel

    Regards,

    Matt Butler, MBA, BSIT/SE, MCBP
    Owner, Intense IT, LLC
    Find us on Facebook
    Follow us on Twitter
    Link up on LinkedIn
    mb (at) i2t.us

    CODE BANK SUBMISSIONS: Converting Images to Base64 and Back Again

  4. #4

    Thread Starter
    Fanatic Member cory_jackson's Avatar
    Join Date
    Dec 2011
    Location
    Fallbrook, California
    Posts
    904

    Re: Command text definitions for ADO to Excel

    Thanks for the links but I don't see where in them it explains the Syntax for an OleDB fill command. What am I missing? And I understand that $ is for a worksheet but I want to find thee reference that details this and the rest of the syntax.

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width