I attempted Arthur's method and almost got it to work but wasn't quite working the way it should. The columns were importing with inappropriate widths, although I did adjust in regards to my data. I also attempted Tom's first method and got stuck. While although its not the best solution I was able to come up with at least a temporary work around so that I can still automate the process. Answer: #1) Import file with tab delimiter #2) Remove commas from all the columns #3) Export with comma delimiter #4) Import file with formats Thank you for your responses & I am still open to more effecient way to accomplish the task of importing a double delimited file, contains tab delimiter & comma delimiter in file to import. For example: company,<tab>companynumber,<tab>DATE ABC,<tab> 1234,<tab>01/01/1987
... View more