Script ASP - Database: Connect to Excel - Morpheusweb.it - Webmaster resources: programming, asp script, using asp, file asp, asp, asp post, database asp, asp login, vb asp, asp access, asp download, asp script, formmail, area riservata, paginazione, scripts asp, mailform, asp script download

ABOUT >
WORKS >
CONTACT ME >
>

Home Page
> Script ASP
> Script ASP Database
> Connect to Excel

Connect to Excel

Script for excel connection as datasource.



					
					'After creating an ODBC connectoin the query is

					SQL = "SELECT * FROM [Foglio1$]" 

					'To read the columns 

					<% 

					valore = rs(n) 

					%>

					'where n is the column number (es. A=0, B=1, etc...)