Problem importing Excel to Access
What, exactly, is in this "field"?
MH
"Oregonnews" wrote in message
...
I have a field in Excel containing numbers. When I import to Access, the
data
is lost. Other numeric fields in the same worksheet are imported just
fine.
This happens both with Access 97 and with Access 2003, and it doesn't
matter
if I save the Excel file to tabbed-text or DBF. The text file shows the
data
right there, but when I import to Access, the numbers just disappear.
I also tried importing the field both as text and as numeric format, to no
avail.
As a longtime user of both Excel and Access, I am aware that the programs
often can be picky about formating text and numbers. I usually can make it
work after numerous tricks, but I am now at my wits' end.
|