I want SQL query to retrieve data

[poojadeepak]

Hello.
I am making a VB application with Access database in backend. I can feed data from datagrid control to database. But I have a problem while retrieving data.
The code used is

  With comSupplier
 .ActiveConnection = conSupplier
 .CommandText = "INSERT INTO temp1 SELECT   Sr_No,Bill_Date,Vend_code,Round FROM PRHD0801 WHERE Bill_Date =" & strName
 .Execute
End With

While debugging I get value of strName but problem while executing.
Please give me any idea.

[debasisdas]

If you are trying to retrieve records, why are you using the INSERT command?

[poojadeepak]

If you are trying to retrieve records, why are you using the INSERT command?

I have a table with details record. I am using blank temp for filling data ,send the data from temp to detail & delete data from temp.When I am trying to retrive data I want to transfer data from detail to temp which satifies the condition
After that I can see the data from temp.The problem is in inserting.

[Killer42]

Well I must say, your WHERE clause looks very questionable. Are you sure that's the correct field (Bill_Date) and variable (strName)?

And regardless of the answer to the above, have you considered the issue of delimiters? Unless it's a numeric field it will need some sort of delimiters around the value. Are they already present in variable strName?