Can anybody help me with the following:
1. I am trying to open an excel file using adodb connection but i got a run time error on the rs. open. Here is my code
Dim cnn As New ADODB.Connection, rs As New ADODB.Recordset
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\temp\XLS.XLS;Extended Properties=Excel 8.0;"
rs.Open "select * from data", cnn, adOpenStatic, adLockOptimistic, adCmdText
2. Can somebody show how to insert or delete or add a column of a recordset on the fly or at run time.