Hi all,

I have a master table employee , which contains the details of employees .

i have to upload the the data to this table from thye excel sheet by using asp.

that is -- what i have to do is , I have to provide a interface to browse the the excel sheet by user , afetr browsing the sheet user will submit the page and i have to read all the rows of excel sheet and update the table . if id exists in the table , then update the data otherwise append the data .

table strucure-----

empid varchar 20
firstname varchar 50
lastname varchar 50
date of joining datetime
city varchar 50
pin varchar 6
phone varchar 20
process varchar 50
sub process carchar 50
email address varchar 50
etc...
there are 20 field to be read from the excel sheet .

any one , help me to achieve this task , i m not getting it , how to do this ,




Rgds
Rajiv

Following the script to read data from excel sheet.. You can change it according to your requirement.


    set dbExl = server.createobject("adodb.connection")
    set rsExl = server.createobject("adodb.recordset")



    connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=records.mdb ;Extended Properties=""Excel 8.0;HDR=Yes"""
        dbExl.ConnectionString = connstr
        dbExl.Open

         sheetName = "Exl-sheet"
           strQry = "select * from ["&sheetName&"$]"
         rsExl.Open strQry, dbExl


do while not rsExl.eof

ID = rsExl(0)
FNAME = rsExl(1)
LNAME = rsExl(2)

rsExl.movenext
loop

thanx dear , i will try to implement it,

thanx for your response

Rajiv