Posted by Richard Gokool on April 30, 2001 12:10 PM
I was wondering if there was a way to modify the way Excel imports a CSV. My problem is that the data from my DB is always exported as a CSV but when I import this same file i lose all the leading zeros. The leading zeros are present in the exported csv but, i guess, Excel then converts the columns with the "general" Tab on instead of the text. Excel imports in one step so my question is:
IS there a way to modify the automatic CSV import program in Excel?
The only solution I have found is to eliminate the extension and import it the long way.
any help would be greatly appreciated.