dcsimg
www.webdeveloper.com
Results 1 to 2 of 2

Thread: Exporting Excel data into Sql - how to read first row

  1. #1
    Join Date
    May 2005
    Posts
    29

    Exporting Excel data into Sql - how to read first row

    Hi there,
    Can any one help me out!!
    I have to export excel data into sql table using asp..
    I tried hard, and finally got a solution.. thanks to the webdeveloper forum which helped me over this..
    My problem comes here..

    When i read the excel file, there should be a column heading in the first row followd by data..
    if i remove the heading then the first line will be the data line and its not reading the first line..
    How can i do this..
    I want it to read the first line of data even though no heading is present..
    Thanks in advance
    Regards

  2. #2
    Join Date
    Jan 2003
    Location
    USA
    Posts
    688
    Assuming a .csv file (which can be opened in Excel) I think with this connection string you could change HDR=Yes to be HDR=No instead:

    http://www.carlprothman.net/Default....crosoftJetText

    And for some related links:

    Using Excel Spreadsheets as Web Data Sources by Steven Raines - 11/23/1999
    http://www.algonquinstudios.com/Home...WebDataSources

    Extract data from Excel Spreadsheet using ASP by Nabeel Akhtar - 9/25/2005
    http://www.geekpedia.com/tutorial143...using-ASP.html

    VBScript and Excel
    http://www.greggriffiths.org/webdev/both/excel/
    Last edited by Bullschmidt; 12-06-2005 at 08:42 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles