IMPORTING ALPHA NUMERIC TO ACCESS FIELD WHY #'S

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
THANK YOU KARL BUT THAT DID NOT WORK. PF

KARL DEWEY said:
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.
Click to expand...
 
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 .
 
Back
Top