VBA SQL SERVER query

[BananaQuaaludes]

Hello,

I have the following query in an Excel vba macro:

SELECT [DELTEK_ORG_ACCT].[ACCT_ID] , [DELTEK_ACCT].[ACCT_NAME] FROM DELTEK_ORG_ACCT INNER JOIN DELTEK_ACCT ON [DELTEK_ORG_ACCT].[ACCT_ID]=[DELTEK_ACCT].[ACCT_ID] WHERE ((([DELTEK_ORG_ACCT].[ORG_ID])='1.1201.01'));

and I get the following error:

run time error 3001: arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

I think it doesn't like my inner join, but I'm not sure why.

Any help would be appreciated!!

 

[donutman]

ON [DELTEK_ORG_ACCT].[ACCT_ID]=[DELTEK_ACCT].[ACCT_ID] WHERE ((([DELTEK_ORG_ACCT].[ORG_ID])='1.1201.01'
I agree with you, there's probably something wrong with the inner join. I'm guessing that either ACCT_ID in the two tables are not defined the same way or ORG_ID isn't a varchar (or char) field. Maybe it's nvarchar, in which case you have to say
WHERE ((([DELTEK_ORG_ACCT].[ORG_ID])=N'1.1201.01'
-Karl

 

[BananaQuaaludes]

Hello Karl,

Thanks for the reply. The error I was getting actually had nothing to do with the join. Apparently VBA likes to see a dot notation between the database name and the table name, as well as between table and column names.

It has to be: database.table.column

Once I changed that it worked. I would have pulled the post down, but didn't see a way to do that.

Thanks anyway!