Community archive

Ask something
Discussion Locked

Excel field will not hold cell format on

0 helpful
3 replies

by jowersda

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a Excel cell with alphanumeric characters, I have formated it to Text and General and saved the Excel file. When I import to Access it imports data as a number field. No matter what I do it keeps bringing it over as a number, consequently all of the data is not importing.

3 replies

by dklippert

Access looks at the first entry to determine the field type. Either insert a "fake" entry, sort so that a "text" looking field is first, or import using the parsing engine.

You could save as CSV and use an extension like .DAT

This discussion is closed to new replies.