Hi all
New to Access 2010.
I'm trying to do a link to the data source by creating a linked table in excel 2010.
Column N was formmated as GeneraI and I got #Num! I have formmated Column N as text but still get the error
#Num!
#Num! is shown for cells that have 4½ shd 3¾ etc
Other cells in the column have numbers 10 31 7 etc.
How can I get around this error of importing this data.
Using Office 2010
Thanks in advance
Graham
New to Access 2010.
I'm trying to do a link to the data source by creating a linked table in excel 2010.
Column N was formmated as GeneraI and I got #Num! I have formmated Column N as text but still get the error
#Num!
#Num! is shown for cells that have 4½ shd 3¾ etc
Other cells in the column have numbers 10 31 7 etc.
How can I get around this error of importing this data.
Using Office 2010
Thanks in advance
Graham