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

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.
 
K

KARL DEWEY

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.
 
K

KARL DEWEY

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.
 
Top