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

RE: Numeric Data values messed up with linking excel files

P: n/a
Hi,

I have a perfect file called "Products.xls" 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 "tblProducts" are incorrect. For example the tblProducts
has a field called "PackageSize" 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
Jul 18 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi Agarwasa,

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

http://accessprogrammer.blogspot.com...ing-excel.html
http://groups.google.com/group/micro...8db71d7bd3c5f2
Bonnie
http://www.dataplus-svc.com

ag**********@gmail.com wrote:
>Hi,

I have a perfect file called "Products.xls" 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 "tblProducts" are incorrect. For example the tblProducts
has a field called "PackageSize" 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.com
http://www.accessmonster.com/Uwe/For...ccess/200807/1

Jul 19 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.