How to INSERT SQL statements INTO table
In MS Access, how do I insert a row which has one column that takes an SQL statement (SELECT) as value? In other words, how开发者_高级运维 to I tell the SQL interpreter not to try to parse that statement and give me errors?
Wrap it in quotes like any other character.
INSERT INTO myTable
('MySQLColumn')
VALUES
('SELECT * FROM MyOtherTable')
精彩评论