How to read data from Excel using ASP and load it in Database (SQL)

[najjar]

Hello,
I have an Excel File and it contains 1368 different
E-Mails and If you did not help me with how to

1- Read the data from the excel file.
2- Insert these data into my database
which is SQL Server.

Please help me or I'll make you type it manually
insted of me
Thank You

 

[FengShui1998]

najjar,

This should help you read in your Excel file.

Set objXL = WScript.CreateObject("EXCEL.application&quot
' objXL.Visible = True
objXL.WorkBooks.Open "C:\mydir\MyExcel.xls"
Set objWkBook = objXL.Workbooks.Item("MyExcel.xls&quot
Set Actv = objWkBook.Worksheets("sheet1&quot

rows = Actv.UsedRange.rows.Count
cols = Actv.UsedRange.columns.Count

For Irow = 1 to rows
For Icol = 1 to cols
xval = Trim(Actv.Cells(Irow,Icol).Value)
Next
Next ' Next row


fengshui_1998

 

[najjar]

I want to thank you
I didn't try it yet
but it looks good to me
thank you agian

 

[forecasting]

Alternatively, you could use ADO

HOWTO: Use ADO with Excel Data from Visual Basic or VBA (Q257819)

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q257819

You can also just copy the data into Access and then export it to SQL Server.