J
Joe Blow
Hello All:
Hope someone can help. When I link to an Excel file, one field contains
mixed alpha and numeric data.. ie:
123
456
ABC
DEF
789
What I see in Access in the linked table is:
#NUM
#NUM
ABC
DEF
#NUM
I've changed the Format in Excel to "Text" instead of "General" and it is
still doing it...
Any ideas?
Oh, both Access 2000 and 2003 are doing this... And the Excel file is Excel
2000 (I think).
Thanks,
Joe
Hope someone can help. When I link to an Excel file, one field contains
mixed alpha and numeric data.. ie:
123
456
ABC
DEF
789
What I see in Access in the linked table is:
#NUM
#NUM
ABC
DEF
#NUM
I've changed the Format in Excel to "Text" instead of "General" and it is
still doing it...
Any ideas?
Oh, both Access 2000 and 2003 are doing this... And the Excel file is Excel
2000 (I think).
Thanks,
Joe