Insert Statement

[Guest]

Hello,

Does anyone know how to write a SQL Script for Access 2007 that will allow
all fields to be selected? I created the following script and successfully
executed it in Access 2003 but it will not work in 2007:

UPDATE EXISITNG TABLE

INSERT INTO [2007 History Table]
SELECT *
FROM [February UNION QUERY]
WHERE [Feb-07 Closed] IS NOT NULL

Thank you

 

[Guest]

If you copied and pasted your code then "EXISTING" is spelled incorrectly.

Sorry, that's all I got.