import CSV

[Milton Snider]

I am trying to import a csv file into excel or access(both are XP verson).
Both apps use the General format meaning if it thinks a field is a date it
makes it a date. I need this turned off. I want 5-9 to remain 5-9. Please
help
thanks

 

[Beege]

I am trying to import a csv file into excel or access(both are XP verson).
Both apps use the General format meaning if it thinks a field is a date it
makes it a date. I need this turned off. I want 5-9 to remain 5-9. Please
help
thanks

Milton,

I think you can rename the .CSV file to .TXT, import that, and it then
gives you the option to format specific columns as it's imported.

Beege