How to use Quotations in a ADO sql string?

[bradyboyy88]

Imagine I have a query saved in a string variable that is passed to an Connection.Open command via ado. The problem I am having is that I dont know how to get to use double quotes in my sql code in my excel vba code.

An example is as follows:

SqlQuery="Select Table1.STATE_ABREVIATION & "-" & Format(Table1.IDS,"00000000")) AS IDS_for_Display From Table1"

This draws an error. I tried to double up my quotes as follows but still draws an error.

SqlQuery="Select Table1.STATE_ABREVIATION & ""-"" & Format(Table1.IDS,""00000000"")) AS IDS_for_Display From Table1"

 

[bradyboyy88]

Any ideas?

 

[Fazza]

some ideas, yes.

it is best to explain what the error is. Simply stating "This draws an error" without explaining the error is not very helpful

when I run the code it does not error

debug.print the string to see if it is what you're expecting
when I debug.print there is no issue

maybe your SQL uses ' instead of " for text. so

SqlQuery = "Select Table1.STATE_ABREVIATION & '-' & Format(Table1.IDS,'00000000')) AS IDS_for_Display From Table1"

Maybe the table & field names don't match the database table & field names?
Does the database have a table Table1?
Does the table have fields STATE_ABREVIATION and IDS

just in case it helps, where I live ABBREVIATION would be expected, not ABREVIATION

all the best