Excel Spreadsheets in asp

Results 1 to 4 of 4

Thread: Excel Spreadsheets in asp

  1. #1
    Join Date
    Dec 1969
    Posts
    778

    Default Excel Spreadsheets in asp

    i need to write an asp script which will read the contents of an excel spreadsheet into a recordset. I have tried to link the sheet to an access database and use the ado to access the sheet through the database, but no go. Access Denied.<BR><BR>Is there a way i can open the spreadsheet directly? I have tried searching for source code, articles, ect, but i can only find information on creating spreadsheets and coppying them into access databases.<BR><BR>Any help would be greatly appreciated.

  2. #2
    Shawn Clabough Guest

    Default RE: Excel Spreadsheets in asp

    I haven&#039t used one before, but you can create ODBC connections that link to an Excel spreadsheet.

  3. #3
    Jason Buck Guest

    Default RE: Excel Spreadsheets in asp

    http://support.microsoft.com/support/kb/articles/q189/1/98.asp<BR><BR>Above is the link to the knowledge base article on the microsoft site.<BR><BR>This will show you exactly how to read from a spread sheet and write to it as well.<BR><BR>Respectfully,<BR><BR>Jason<BR>webmast er@wnj.com

  4. #4
    Join Date
    Dec 1969
    Posts
    778

    Default RE: Excel Spreadsheets in asp

    My thanks, that is exactly what i was looking for.


Posting Permissions

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