IMPORTING ALPHA NUMERIC TO ACCESS FIELD WHY #'S

[Guest]

ACCESS 2002. WHEN IMPORTING AN ALPHA NUMERIC FIELD FROM EXCEL TO ACCESS THE
NUMBERS ARE #'S. YET IF I IMPORT ONLY A NUMERIC FIELD FROM EXCEL TO ACCESS
THE NUMBERS ARE CORRECT.

 

[Guest]

Put a phony row of data just under your column titles with text in the
columns that have both text and numbers. That way Access will know the
column is text.

 

[Guest]

THANK YOU KARL BUT THAT DID NOT WORK. PF

Put a phony row of data just under your column titles with text in the
columns that have both text and numbers. That way Access will know the
column is text.

 

[Guest]

Give an example of the data in Excel and what it looks like in Access.

 

[Guest]

IN EXCEL THE ACCOUNT # IS 457KAA. WHEN IT GOES INTO ACCESS IT BECOME ######.
IF THE ACCOUNT # IS 951354 IN EXCEL IT STAYS AS 951354 IN ACCESS. THE FIELD
IS TEXT IN ACCESS .