Insert Sql Statement - 10-06-2003 , 05:08 PM
What is the syntax to insert a field data using a
TableName = Variable
I have a sql
Insert into TESTTABLE Item, Price From Tablename
I have a field TESTTABLE called Table, I need to include
in my insert statement to have Table = TableName.
I have tried the Set Table = TableName but got an error.
Can someone help me?
Re: Insert Sql Statement - 10-07-2003 , 09:08 PM
You might use dynamic SQL, try this link
Ray Higdon MCSE, MCDBA, CCNA
"Vina" <tvae (AT) att (DOT) net> wrote