configuring double click to import file correctly

I have an email attachement that comes across with the naming standard of *.dat    the .dat portion cannot be changed as this is coming from an external system.  The problem is that this file is actually a comma delimited file.  and when I associate this file with Excel, a double click brings it in as a text file and does not parse out the appropriate columns as specified by the commas.

Is there anyway to configure Excel (2007) to be able to import this like a .csv file without the appropriate extension?

 

Thank you

your best bet here is to remove the extension and then the text import wizzard will start.Select delimited in the first part and click end. Not sure however why you can't change the extension from .dat to .csv manually?

We certainly could do this manually, however the CSR would have to do this too many times a day, every day.  Very tedious.  I was hoping for a behind the scenes fix or trick.  Modify the registry or a config file to be able to look at this as a .csv. 

 

thanks