X++ ODBC Connection to text file for importing

Posted on behalf of Mark Kopan.

I am trying to create an ODBC Connection string to an external tab delimited flat text file in X++. I have not been able to figure out how to perform a connection via ODBC. File could be either .txt or .xls. This is a bulk data load from an AS400 legacy system. Data has to be exported and scrubbed before import into Axapta, hence the need to have it in a flat file for loading.