Using EXCEL data source with ASP code

Results 1 to 3 of 3

Thread: Using EXCEL data source with ASP code

  1. #1
    aydans@garanti.net.tr Guest

    Default Using EXCEL data source with ASP code

    I want to use an Excel file as datasource. <BR>I have an excel file deployed in my web server and i want to read and change the data in this file with ASP code.<BR>How can i connect to this file and how can i read the records from it with ASP code.<BR>set rcSet=conn.execute("select * from excelfile")--&#062;doesnt work<BR><BR>I need help as soon as possible !<BR>Thank you

  2. #2
    Join Date
    Dec 1969
    Posts
    1,019

    Default RE: Using EXCEL data source with ASP code

    Use this format:<BR>"SELECT * FROM `Sheet1$`"<BR>where Sheet1 is the name of the worksheet; you must add the dollar sign at the end and surround the whole thing with the single quote ` from under the tilde ~ on a QWERTY keyboard.<BR>

  3. #3
    aydans@garanti.net.tr Guest

    Default RE: Using EXCEL data source with ASP code

    Thank you for your help :)))

Posting Permissions

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