deadseasquirrels
Board Regular
- Joined
- Dec 30, 2004
- Messages
- 232
I've been trying to execute this SQL string for the longest time:
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?
Code:
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"