Append Query to Insert Table Name

J

Jason Rhymes

Is there a way to have a Append query insert the table name it came from as
one of the fields? And maybe also a date stamp?
 
J

JohnFol

Yes,

INSERT INTO Table2 ( field1, field2, field3 )
SELECT "Table1" AS Expr1, Date() AS Expr2, Table1.field3
FROM Table1;
 
J

Jason Rhymes

That works. I had to take Table1.field3 out because it came up w/ a dialog
box to type info for it. And I changed Date to Now to get a more accurate
reading. Thanks
 
Top