Numeric Values for Primary Keys Only???

C

CMV

I have two tables...one of which holds userid's, firstnames, and lastnames of
employees. Some of the id's are all numeric, and some are all characters.
When I import my Excel spreadsheet, it takes all the id's with characters
out. Any help or suggestions???
 
V

Van T. Dinh

It sounds to me that you have 2 spreadsheets with mixed Columns and you want
to import them into Access???

Excel allows mixed Columns, Access doesn't. In Access, a Column / Field
type must be either Numeric or Text, not both. Note that a Text value can
contain only digit characters so a Column in Access may look like a mixed
Column.

If you import a mixed Column from Excel into Access, you need to convert the
mixed values to a single type before importing into Access.
 
Top