J Jim Heavey Nov 28, 2003 #1 Does someone have an example of accessing an Excel spreadsheet using ASO.Net? Thanks in advance for your assistance!
Does someone have an example of accessing an Excel spreadsheet using ASO.Net? Thanks in advance for your assistance!
M Miha Markic Nov 28, 2003 #2 Hi Jim, Try using OleDbConnection with the connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=FILENAME.xls;Extended Properties=\"Excel 8.0; IMEX=1\"; The use a OleDbCommand with CommandText like: SELECT * FROM [Sheet1$] HTH,
Hi Jim, Try using OleDbConnection with the connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=FILENAME.xls;Extended Properties=\"Excel 8.0; IMEX=1\"; The use a OleDbCommand with CommandText like: SELECT * FROM [Sheet1$] HTH,
V Val Mazur Nov 29, 2003 #3 Hi Jim, Check next example http://support.microsoft.com/default.aspx?scid=kb;en-us;316934&Product=adonet
Hi Jim, Check next example http://support.microsoft.com/default.aspx?scid=kb;en-us;316934&Product=adonet
