import an excel file to access dbase using ASP? 2

[daveigh]

hi all, does anybody hav a link or knows a way how to import an excel file to access dbase using ASP? ive been searching in google & im not satisfied with the results..any code snippet is very much appreciated. tnx!

_______________CRYOcoustic_____________

 

[shaddow]

This could help

Dim objXlApp, objXlSheet

' create the Excel object
Set objXlApp = Server.CreateObject("Excel.Application")

' open the spreadsheet file
objXlApp.Workbooks.Open Server.MapPath("excelfile.xls")

' get the worksheet
Set objXlSheet = objXlApp.Worksheets("Sheet1")

' read from the worksheet
Response.Write(objXlSheet.Range("B1").Text)

' clean up
Set objXlSheet = Nothing
objXlApp.Workbooks.Close
Set objXlApp = Nothing

If you are familiar with VBA fro Excel then this is what you would need.
Or ODBC way

http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForExcel

________
George, M

 

[fark]

Found this post through a google search and it is exactly what I was looking for. I ran the code though and got this error message:

Server object error 'ASP 0196 : 80040154'

Cannot launch out of process component

/TestExcel.asp, line 5

Only InProc server components should be used. If you want to use LocalServer components, you must set the AspAllowOutOfProcComponents metabase setting. Please consult the help file for important considerations.

Any suggestions on how to get this to run?? Thanks a bunch

 

[shaddow]

Then you cant use Excel.Application there for you would need to access database using it as Database.

http://www.able-consulting.com/ADO_Conn.htm

________
George, M

 

[Siddhamalli]

Hi iam also looking for something like this can you please let me know the result please give me a sample code for this , thank you

 

[shaddow]

You can take a look here.

http://support.microsoft.com/default.aspx?scid=kb;en-us;195951&Product=mdac

________
George, M
Searches(faq333-4906),Carts(faq333-4911)