Microsoft Access automatic formatting of excel spreadsheet RRS feed

  • Question

  • In both Access 2013 and 2016 versions, how does Access determine how to automatically format excel data?

    I'm importing excel spreadsheets that have 'general' format. When I import it into Access, it will automatically format the data as either text or number. I want it to automatically format it as text, because the data can sometimes contain both letters and numbers. My theory is that Access looks at all the data in the column and if MOST of the data is number only, it will auto format it as number; if most of the data has numbers AND letters in each cell then it will auto format it as text. 

    Can you please confirm whether this is how Access determines formatting?

    I DO NOT need to know how to MANUALLY format the data. We already know how to do this. 

    Thank you!

    Monday, December 4, 2017 11:15 PM