Results 1 to 2 of 2

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

  1. #1
    Join Date
    May 2005

    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

  2. #2
    Join Date
    Jan 2003
    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:


    And for some related links:

    Using Excel Spreadsheets as Web Data Sources by Steven Raines - 11/23/1999

    Extract data from Excel Spreadsheet using ASP by Nabeel Akhtar - 9/25/2005

    VBScript and Excel
    Last edited by Bullschmidt; 12-06-2005 at 08:42 AM.
    J. Paul Schmidt
    www.Bullschmidt.com - Freelance Web and Database Developer
    www.Bullschmidt.com/DevTip.asp - Classic ASP Design Tips

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