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

Linked Table Problem

P: n/a
Hi

I have a a fairly large Excel sheet that I linked to from Access.
Everything seems to work fine except for one field.

The priority field is a text field and can have values such as
1,2,3,3a,3b,3c, however, when viewed in access the values 3a, 3b, 3c
appear ok, but those with just 1,2,3 have the value #Num!

The cell format in Excel is set to text and the field format in access
is set to text. So does anyone have any ideas how to resolve this?

Thanks for any suggestions.
Paul

Aug 7 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Just in case anyone was interested, i managed to resolve the problem by
re-typing the numbers over themselves in Excel, bizarre behaviour....

Paul
pa************@hotmail.com wrote:
Hi

I have a a fairly large Excel sheet that I linked to from Access.
Everything seems to work fine except for one field.

The priority field is a text field and can have values such as
1,2,3,3a,3b,3c, however, when viewed in access the values 3a, 3b, 3c
appear ok, but those with just 1,2,3 have the value #Num!

The cell format in Excel is set to text and the field format in access
is set to text. So does anyone have any ideas how to resolve this?

Thanks for any suggestions.
Paul
Aug 7 '06 #2

P: n/a
This is because the data was entered first, then the cells were changed to
text format, this doesn't affect the data that's already entered though.

The quick way (if there are a few cells) to update this is to step into each
cell, hit the F2 key and then hit enter, you don't have to type the data in
again.

--

Terry Kreft
<pa************@hotmail.comwrote in message
news:11**********************@n13g2000cwa.googlegr oups.com...
Just in case anyone was interested, i managed to resolve the problem by
re-typing the numbers over themselves in Excel, bizarre behaviour....

Paul
pa************@hotmail.com wrote:
Hi

I have a a fairly large Excel sheet that I linked to from Access.
Everything seems to work fine except for one field.

The priority field is a text field and can have values such as
1,2,3,3a,3b,3c, however, when viewed in access the values 3a, 3b, 3c
appear ok, but those with just 1,2,3 have the value #Num!

The cell format in Excel is set to text and the field format in access
is set to text. So does anyone have any ideas how to resolve this?

Thanks for any suggestions.
Paul

Aug 7 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.