I found it online. In case anyone else has the same problem, add IMEX=1 to the end of the connection string in the Properties of the Connection...
Hello. I'm trying to import an excel file that is sent from an outside source, several times a month, and loaded into sql '05. All of the columns...
i had tried that but it still was not working. i moved the left outer join to the end of the query and changed it to a where work_atty NOT IN...
Hello. I have a main query joining to multiple subqueries. One of the subqueries' result set however needs to be eliminated from the overall result...
Separate names with a comma.