[lymni22]

Hello friends

i had my data with excel file.
i want to import my excel data to my sql server database
after that i want add one image file
then i display the records using asp page
i want to know how to retreive records from Excel file to database?

thanks in advance
Lymni

you can treat an excel file like a database, it just a matter of the connection string being used then you treat it just like a table in a database

http://www.able-consulting.com/MDAC/...DriverForExcel

[erickoh]

Hi koncept,

I got the driver from the link you provided,

oConn.Open "Driver={Microsoft Excel Driver (*.xls)};" & _
"DriverId=790;" & _
"Dbq=c:\somepath\mySpreadsheet.xls;" & _
"DefaultDir=c:\somepath"

but it still return an error msg as below:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Excel Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt.

/eSITE/excel.asp, line 15

Do you know what happen? Can teach me ? Please.

this is the code i am using to open the excel file, im working on extracting data now. this is a new thing, i just knew it was possible

Code:

dim adoCon
dim strCon

Set adoCon = Server.CreateObject("ADODB.Connection")

strcon ="Driver={Microsoft Excel Driver (*.xls)};" & _
		   "DriverId=790;" & _
		   "Dbq=demo.xls;"
'Set an active connection to the Connection object
adoCon.Open strCon

i know i should edit that last post but
this is it, compliments of google n hotscripts

http://www.codeave.com/asp/code.asp?u_log=135

the file with all the stuff im using is called dyne.zip

[dypsoprogram]

Hi,
U will find another great sample at http://dypso.free.fr/tech

[preetinair033]

hi konCept,

Thank you for the code to access the excel sheet value and display in asp.
However, I wished to access the data in the second sheet of the workbook in an excel sheet.
could you help me with the code for the same.
regards
milan

[preetinair033]

hi konCept,

well my issue is sorted out. I am able to retrieve/fetch data from sheet2 of the workbook.

However, I wish to retrieve data from SqL server database and populate the column in Excel and that too in second sheet through ASP.



Could you help me with the Code?


regards
Milan

[charan_124]

Hai Preeti,

Can you help me by providing the code , how to connect the 2nd worksheet of excel. I found lot of codes connecting by "name range" only.

Expecting your reply

Thanks