Insert Statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
If you copied and pasted your code then "EXISTING" is spelled incorrectly.

Sorry, that's all I got.
 
Back
Top