By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,351 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Link Problem (#Num!)

P: 72
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
Feb 21 '07 #1
Share this Question
Share on Google+
5 Replies


P: 72
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
Feb 21 '07 #2

Rabbit
Expert Mod 10K+
P: 12,315
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.
Feb 21 '07 #3

P: 72
beautiful. I learned something new today. Thanks to you.
Feb 21 '07 #4

Rabbit
Expert Mod 10K+
P: 12,315
Not a problem, good luck.
Feb 21 '07 #5

NeoPa
Expert Mod 15k+
P: 31,186
Excel can be a pain like that.
Trying to be clever and making assumptions - often without even providing the facility to override its assumptions.
Feb 26 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.