title: Importing 'numbers stored as text' from Excel to Access in field with 'number' as data type
body: <p>I know I can just convert to number in Excel, but I will be handing this database off to a few users with no Access experience and limited Excel experience--I want as little data manipulation as necessary.  Access use has been reduced to button-clicking and report viewing/printing.  Among these buttons is a data refresh macro--the fewer the steps in preparing the data, the lower the chance of screwing something up.</p>
  
  <p>I'm adjusting a .mdb Access table to include information previously excluded from an Excel import.  A few of these columns are numbers stored as text in Excel, while the columns in Access have datatype set to "Number".  When I import, will Access treat these as a number or a string?</p>
  
  <p>Thanks!</p>