V
Vandy
Hi,
I am trying to insert a table (tabtest) based on the value(accountno)
from the query (qryemployee).
This is the query I have,
strInputFileName = EmployeeName
strSQLtemp = "select accountno from qryEmployee"
strSql = "Insert into tabtest (AccountNo,Name) values (" & accountno &
",""" & strInputFileName & """)"
strSql = strSql & "where accountno in ( """ & strSQLtemp & """ );"
But I am getting error as the semicolon missing at the end of SQL
statement.
I have doubt on the field accountno. Is that correct?
Could you please help me to resolve this?
Thanks in advance.
I am trying to insert a table (tabtest) based on the value(accountno)
from the query (qryemployee).
This is the query I have,
strInputFileName = EmployeeName
strSQLtemp = "select accountno from qryEmployee"
strSql = "Insert into tabtest (AccountNo,Name) values (" & accountno &
",""" & strInputFileName & """)"
strSql = strSql & "where accountno in ( """ & strSQLtemp & """ );"
But I am getting error as the semicolon missing at the end of SQL
statement.
I have doubt on the field accountno. Is that correct?
Could you please help me to resolve this?
Thanks in advance.