Results 1 to 2 of 2

Thread: Excel

  1. #1
    Join Date
    Dec 1969

    Default Excel

    Can I read from an Excel sheet and post the<BR>results to an ASP page?<BR><BR>If can, how should i do it???

  2. #2
    Yes Guest

    Default RE: Excel

    Create an Excel DSN and open as any other db.<BR>"Select * from `Sheet1$`"<BR><BR>Where Sheet1 is the name of the worksheet (not the file), add the dollar sign & the tiks (not single quotes, use tiks under tilde).<BR>HTH

Posting Permissions

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