Stop Converting to Date

[Jerry Baker]

I have a CSV file with a field containing the grade levels of schools
(e.g., 9 - 12). I cannot figure out how to make Access STOP converting
them to dates when importing. This is making me crazy.

Thanks.

 

[dbahooker]

uh import it as text?

 

[Jerry Baker]

I have a CSV file with a field containing the grade levels of schools
(e.g., 9 - 12). I cannot figure out how to make Access STOP converting
them to dates when importing. This is making me crazy.

Thanks.

Sorry. It was Excel's fault. Off to the Excel group.

 

[KARL DEWEY]

Trick it by entering a phony first records that has text in the column.