CODEWITHSUNDEEP
sqlms-accessvba
William
William

Reputation: 9

Insert Into SQL Statement error 3346

I am trying to INSERT INTO a table in SQL but for some reason it says the number of query values and destination fields are not the same and I'm not sure why it is saying that. I have researched the error (3346) with no luck for a fix. I am rather new to VBA so any help would be greatly appreciated.

"INSERT INTO Clients (Col1, Col2, Col3)" & _
        "SELECT DISTINCT DD.[Client ID] " & _
        "FROM " & tableName & " as DD " & _
        "Where CL.[Client ID] NOT IN (SELECT DD.[Client ID] FROM " & tableName & " as DD)"

Upvotes: 0

Views: 1335

Answers (1)

void
void

Reputation: 7890

You are trying to insert into 3 columns from one column it's confused this will work:

"INSERT INTO Clients (Col1)" & _
    "SELECT DISTINCT DD.[Client ID] " & _
    "FROM " & tableName & " as DD " & _
    "Where DD.[Client ID] NOT IN (SELECT DD.[Client ID] FROM " & tableName & " as DD)"

but it does not insert any row because there is no result for select statement. Think a little more on it and decide exactly what do you want to insert into where?

Upvotes: 2

Related Questions