When I double-click a .csv to open it in Excel, I'm losing data (details here, for interest's sake: http://www.experts-exchange.com/Programming/System/Windows__Programming/Q_26427029.html
To resolve this, I want to find a different way of getting my .csv's open in Excel efficiently. I found this forum thread:
which describes how to use Powershell to convert a .csv to .xlsx format. I've never used Powershell, so I don't know it's limitations.
I work on a Windows XP Professional machine, (with full access to Debian Linux should it be helpful, though it's probably not relevant to this question) but I also have some access to Windows 2003 and Windows 2000 servers if necessary.
Can someone please guide me through setting up the script described in the forum above?
I'd need to start right from the basics - can I run Powershell on XP, do I need to download it, how can I set up and run a script etc...