VBA and SQL

[Jishnu Surendran]

I have to insert some data into an .mdb file from an excel worksheet. The ADO connection was created successfully. The 'insert into' query has to be combined with 'where not exists' to avoid inserting duplicate data. I have to select some data from a worksheet of the active workbook (say 'c') to query the 'where not exists' part. Tried the following:
Insert into................Select * From ([c]) Where Not Exists (.......).
I am getting a 'syntax error for from clause' error. Any help on how to select the data from a sheet of current workbook using sql.

 

[QuietRiot]

Can you give us more information? Impossible to help with such little information
IF C is the worksheet not workbook and the column names come after Email, Name etc.
SELECT [C$].Email, [C$].Name FROM [C$] WHERE ...

 

[Jishnu Surendran]

Can you give us more information? Impossible to help with such little information
IF C is the worksheet not workbook and the column names come after Email, Name etc.
SELECT [C$].Email, [C$].Name FROM [C$] WHERE ...

Hi, You've made it simple for me. Taking your example, this query 'SELECT [C$].Email, [C$].Name FROM [C$] WHERE ...' when I am doing it generates a 'syntax error From clause'. Is it possible to select from the worksheet just like 'SELECT [C$].Something'?