Dear Friends,

My code is here:
sSQL = "INSERT INTO Stock VALUES " & _
"SELECT Ticker, Name FROM " & MyTableName & " " & _
"EXCEPT " & _
"SELECT Ticker, Name FROM Stock"

pSQL = "INSERT INTO Price VALUES " & _
"SELECT Ticker, Date, Open, High, Low, Close, Volume FROM " & MyTableName & " " & _
"EXCEPT " & _
"SELECT Ticker, Date, Open, High, Low, Close, Volume FROM Price"

Debug.Print sSQL
Debug.Print pSQL

accApp.DoCmd.RunSQL sSQL
accApp.DoCmd.RunSQL pSQL

The debug.print gives

INSERT INTO Price VALUES SELECT Ticker, Date, Open, High, Low, Close, Volume FROM Hongkong_02102001 EXCEPT SELECT Ticker, Date, Open, High, Low, Close, Volume FROM Price


What's wrong with my code?
Is it Access support the use of EXCEPT?
Thanks