Thank you. I just figured I'd ask to see if anyone else had the issue.

No worries. We have not heard back from your VAR.  Can you make sure that you have the correct configuration for ODBC.  According to your VAR, you have a 64 bit OS with 64 bit Workflow.  You will need to check the client machine where the CSV is located and make sure that your ODBC drivers match the configuration of the server.
You can refer to the configuration here.   Further background information can be found here.

I have installed the Access 2010 distributable like it says in the Workflow Help.

They called me yesterday and took down all my software versions. I am running 64bit Windows Server and Workflow Designer.

What am I looking for on the remote machine to make sure it matches? Will I need to install the 2010 on both?

I have verified I did install the 64-bit Access 2010. It is now on both servers (the Workflow server and the Server with the CSV file) and still does not work. I understand my VAR has made contact.

Yes, thank you. We are asking him for a copy of the workflow WFI file, the query and the CSV you use.  We will be in touch through your VAR.

For the benefit of other readers, the ODBC data type for the field was an integer field.  Setting it to LongChar resolved the issue.