I
ielmrani via AccessMonster.com
Hi,
I linked an excel sheet to my database but 2 fields have the following error:
#Num!
In excel the records look like this;
Plan ID Plan Name1
169 Brickman
1231 Argo
AAM American
ART ArtMine
In the table in the database it looks like this:
Plan ID Plan Name1
#Num! Brickman
#Num! Argo
AAM American
ART ArtMine
Brickman and argo's ids are the only 2 that are numbers. I tried changing
the format fo the cell to text but it did not help
Thanks in advance
I linked an excel sheet to my database but 2 fields have the following error:
#Num!
In excel the records look like this;
Plan ID Plan Name1
169 Brickman
1231 Argo
AAM American
ART ArtMine
In the table in the database it looks like this:
Plan ID Plan Name1
#Num! Brickman
#Num! Argo
AAM American
ART ArtMine
Brickman and argo's ids are the only 2 that are numbers. I tried changing
the format fo the cell to text but it did not help
Thanks in advance