X++ ODBC Connection to text file for importing

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.

Hi Mark, not sure how you managed to post a new thread here. The site has moved to http://dynamicsusers.org I have moved this post to : http://dynamicsusers.org/forums/212/ShowThread.aspx#212