Is there Excel descrepancies with SQL strings

[deadseasquirrels]

I've been trying to execute this SQL string for the longest time:

connString = "Provider=MSDAORA.1;Password=[pwd];User ID=[uid];Data Source=DKARCH1.WORLD;Persist Security Info=True" 
    dbsNDF.connectionString = connString 
    dbsNDF.Open 

    sqlString = "SELECT  SO.PURCHASE.STATUS, SO.STUDENT.ENTRY_DATE, SO.STAFF.USER_NAME, " & _ 
        "SO.PURCHASE.CODE, SO.STUDENT.FIRST_NAME,SO.STUDENT.LAST_NAME " & _ 
        "FROM SO.STUDENT, SO.PURCHASE " & _ 
        "WHERE   SO.STUDENT.ENTRY_USER_ID = SO.STAFF.ID " & _ 
        "AND     SO.PURCHASE.PRODUCT_ID = SO.PRODUCT.ID" & _ 
        "AND     SO.PRODUCT_GROUP.ID = SO.PRODUCT.PROD_GROUP_ID" & _ 
        "AND     SO.STUDENT.SCHOOL_ID = SO.SCHOOL.ID"

and it just doesn't seem to want to work. And I was wondering if there are any ways I have to edit my SQL string to make them work in Excel. I've created strings that worked before but when I stick in other strings, usually longer ones, it always seems to fail. ANy ideas?

 

[Norie]

What's the problem?

Is it causing errors or not producing the correct result?

BTW you're missing a couple of spaces:

sqlString = "SELECT SO.PURCHASE.STATUS, SO.STUDENT.ENTRY_DATE, SO.STAFF.USER_NAME, " & _
"SO.PURCHASE.CODE, SO.STUDENT.FIRST_NAME,SO.STUDENT.LAST_NAME " & _
"FROM SO.STUDENT, SO.PURCHASE " & _
"WHERE SO.STUDENT.ENTRY_USER_ID = SO.STAFF.ID " & _
"AND SO.PURCHASE.PRODUCT_ID = SO.PRODUCT.ID " & _ <-----Here
"AND SO.PRODUCT_GROUP.ID = SO.PRODUCT.PROD_GROUP_ID " & _ <------And here
"AND SO.STUDENT.SCHOOL_ID = SO.SCHOOL.ID"

 

[deadseasquirrels]

It's throwing errors, not even giving me any results. I'll look into the space issue. Thanks for the help.