Link Problem (#Num!)

[ielamrani]

Hi all,
I Linked an excel sheet to a database but I am experiencing the following the issue:

Excel Sheet Database table

Plan ID Plan Name Plan ID Plan Name

169 John Smith Co 169 John Smith Co
AAM Anesta #Num! Anesta
ACOU Account #Num! Account
ENER Energy Co #Num! Energy Co

Can anyone tell me why I am getting an error in the database table on Plan ID?

Thanks

Ismail

[ielamrani]

Sorry the data is not in order here is the data again:

Excel Sheet

Plan ID Plan Name

169 John Smith Co
AAM Anesta
ACOU Account
ENER Energy Co

Database table

Plan ID Plan Name
169 John Smith Co
#Num! Anesta
#Num! Account
#Num! Energy Co

Plan ID and Plan Name are 2 different fields

[Rabbit]

Using the first value as the field's prototype, the link is assuming that Plan ID is a numeric field. When it hits those strings, it doesn't recognise it as a number, hence the errors. Try putting a record with a Plan ID that has text as the first record.

[ielamrani]

beautiful. I learned something new today. Thanks to you.

[Rabbit]

Not a problem, good luck.

[NeoPa]

Excel can be a pain like that.
Trying to be clever and making assumptions - often without even providing the facility to override its assumptions.