Within the Text import Wizard, the default delimiter is TAB. Is it possible to permanently modify this default to be a comma?
How do I get the control indicated below to be selected by default? That way, I could just open a CSV file and hit "Finish" with no further clicking.
Regardless of the file extension (in this case, I'm mostly concerned about .CSV files) or the delimiter (in this case, I'm looking at commas since that's what the 'C' in CSV stands for), when I select File / Open (from within Excel) the Text Import Wizard always selects TAB as the delimiter. Of course, I can remove the check and place a check by the comma, but can I make that solution permanent?
No modification of Control Panel Regional Settings seems to work. It's very frustrating as I would never use anything other than a comma in a file of "Comma Separated Values"! I'd certainly never use the tab character in the creation of a table in a text file.