Search results

Thanks Doc, first part now runs fine, any ideas on the second. Probably another comma issue!

Thanks DR Snuggles but I think it might be the "FROM" statement. I did change the code to what you suggested but no joy. Does anyone know the rules on a SELECT statement?

I'm running a VBA query in excel trying to import the field from a table, simple so I thought, any idea on why i'm getting syntax error codes on this part? Application.StatusBar = "Retrieving Depot Names" sSQL = "SELECT tbldepot.DepotName 'Depot' " & vbCr & _ "FROM tbldepot, "...