Importing .xls into access and losing field values that contain al

  • Thread starter Thread starter rciolkosz
  • Start date Start date
R

rciolkosz

When I am importing and xls file into access I lose cell values that contain
alpha as part of the part number. I have tried changing field value to text
and that doesn't work.
 
Add a phony row of data just below the column names to let Access know what
the datatype for the field is to be as it looks at top and if it sees a
number it thinks everything in the column is a number.

Or create the table in Access and append the Excel file.
 
If you are mixing them in a field then character that resemble numbers are
treated as text. If you wish to do math they will need to be converted in
your query and trap any text that will not convert.
 
Back
Top