Excel 2007

Re: configuring double click to import file correctly

kiethb1967 — Wed, 10 Mar 2010 18:23:37 GMT

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

Re: configuring double click to import file correctly

Nick Hodge — Wed, 10 Mar 2010 18:13:27 GMT

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?

configuring double click to import file correctly

kiethb1967 — Wed, 10 Mar 2010 17:37:29 GMT

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