pramoc
05-07-2007, 01:25 AM
i have one excel sheet report1 with 900 records generated on 1st of month .
then i have report 2 with 1200 records generated on 30 th of month
I run this query on report 2 it runs sucessfully but not on report1
.
str1 = "select * from [sheet2$] where profitctr in (Select pc1 FROM [pc$])"
If objRecordset.State = 1 Then objRecordset.Close
objRecordset.Open str1, objConnection, adOpenStatic, adLockOptimistic, adCmdText
only columns i am concerned with are
column d
column bp
plz help
then i have report 2 with 1200 records generated on 30 th of month
I run this query on report 2 it runs sucessfully but not on report1
.
str1 = "select * from [sheet2$] where profitctr in (Select pc1 FROM [pc$])"
If objRecordset.State = 1 Then objRecordset.Close
objRecordset.Open str1, objConnection, adOpenStatic, adLockOptimistic, adCmdText
only columns i am concerned with are
column d
column bp
plz help