Numeric Values for Primary Keys Only???

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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6022-numeric-values-for-primary-keys-only.html
When I import my Excel spreadsheet, it takes all the id's with characters
out. Any help or suggestions???

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6022
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6022
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.

--
HTH
Van T. Dinh
MVP (Access)



"CMV" wrote in message
news:E10B96DF-B07F-4F72-B17D-A3018C710D8C@microsoft.com...
>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???