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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert a csv to xls prior to import 2
Importing Text Files Into Access 1
Import from Excel to Access 1
Type Conversion Error While Importing (Time Field) 8
xls 2013 - delete rows if a cell does not contain any of a list of multiple values 0
Date/time field changing seconds to all zeros 3
Importing data 5
Field Type 1

Top