Hi,
How do I customise a SELECT WHERE statement in an OleDbDataAdapter so the WHERE clause is taken from a session variable called Employer? eg instead of
Dim daExcel As New OleDb.OleDbDataAdapter("SELECT * FROM [Sheet1$] WHERE Employer='EmployerA'", cnExcel) I want to replace the hardcoded EmployerA with the value of the session variable Employer. the problem is with the single and double quotes!!!!!
Thanks in advance, Any advice would be more than welcome.
geor68
How do I customise a SELECT WHERE statement in an OleDbDataAdapter so the WHERE clause is taken from a session variable called Employer? eg instead of
Dim daExcel As New OleDb.OleDbDataAdapter("SELECT * FROM [Sheet1$] WHERE Employer='EmployerA'", cnExcel) I want to replace the hardcoded EmployerA with the value of the session variable Employer. the problem is with the single and double quotes!!!!!
Thanks in advance, Any advice would be more than welcome.
geor68