RE: Numeric Data values messed up with linking excel files

[agarwasa2008@gmail.com]

Hi,

I have a perfect file called "Products.x ls" that I link to my MS
Access 2003 database and everytthing looks good in that file.

When I view the same file after linking in my database the data values
of records in "tblProduct s" are incorrect. For example the tblProducts
has a field called "PackageSiz e" as listed below. THe problem is that
it displays the text correctly but if the field has numbers only it
messes it up. I have set this field in the xls file as "Format Cell as
Text" to accommodate the number and text which is fine in the .xls
file but it get messed up in the linking proceses. Any magic to fix
this problem

Thanks,
Sa

Example:
Package Size (Field in tblProducts)
2LED
#Num!
#Num!
#Num!
T13/4
D041
SLP2510P8
SFH206K

[bhicks11 via AccessMonster.com]

RE: Numeric Data values messed up with linking excel files

Hi Agarwasa,

Here's two different threads regarding that behaviour. Should help:

http://accessprogrammer.blogspot.com/2005/03/num-error-when-linking-excel.html

http://groups.google.com/group/microsoft.public.access.externaldata/browse_thread/thread/438db71d7bd3c5f2

Bonnie

http://www.dataplus-svc.com

agarwasa2008@gm ail.com wrote:

>Hi,
>
>I have a perfect file called "Products.x ls" that I link to my MS
>Access 2003 database and everytthing looks good in that file.
>
>When I view the same file after linking in my database the data values
>of records in "tblProduct s" are incorrect. For example the tblProducts
>has a field called "PackageSiz e" as listed below. THe problem is that
>it displays the text correctly but if the field has numbers only it
>messes it up. I have set this field in the xls file as "Format Cell as
>Text" to accommodate the number and text which is fine in the .xls
>file but it get messed up in the linking proceses. Any magic to fix
>this problem
>
>Thanks,
>Sa
>
>Example:
>Package Size (Field in tblProducts)
>2LED
>#Num!
>#Num!
>#Num!
>T13/4
>D041
>SLP2510P8
>SFH206K

--
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200807/1