asp and excel

Results 1 to 2 of 2

Thread: asp and excel

  1. #1
    Join Date
    Dec 1969

    Default asp and excel

    I need to use asp to open an excel file, then get data from each cell and add to database.<BR><BR>any idea?

  2. #2
    Join Date
    Dec 1969

    Default You can treat Excel as DB...

    You can actually open an Excel sheet as if it were a table in a database.<BR><BR><B R><BR>Scroll down to "You can also open an Excel Spreadsheet using the JET OLE DB Provider"<BR><BR>And do follow the link to the MSDN article, especially to learn about how to specify which table and/or range of cells to use.<BR><BR><BR><BR>

Posting Permissions

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