Syntax error when using Except

[steenesse]

I have never used the EXCEPT clause in FROM and when I try I get syntax error. Can anybody tell me what's wrong with the following code:

CsSQL = "SELECT FileName FROM tblFTPFileList EXCEPT SELECT FileName FROM Imports;"
Set fname = CurrentDb.OpenRecordset(CsSQL)

Both SELECT Queries word by them selves, but why I try to combine them with EXCEPT, I get syntax error. I have tried brackets, but nothing works.

[orange]

Did you find some documentation that indicated MSAccess SQL uses/is compatible with the EXCEPT statement?
I have not seen nor found any such statement. I have seen T-SQL /SQL Server reference.
Perhaps you could tell us what you are trying to accomplish and readers will offer some options.

[steenesse]

Doh ! I see you're right. I'll find another way. Thanks

I was trying to create automatic FTP download and import of files that haven't been downloaded , keeping a list in a separate table of what's imported.

[Minty]

I'm pretty sure you could use the Not In syntax, something like

CsSQL = "SELECT FileName FROM tblFTPFileList Where Filename Not IN( SELECT FileName FROM Imports);"