Debbie Elam
delam at zyterra.com
Wed Nov 5 13:49:57 CST 2008
That occurred to me just a few minutes ago too. I am trying to get all of them as text, since there are 0s that get dropped in number format that are meaningful. I am still getting link as numbers, and the same fields are not coming through despite all being text now. I think this may be the right track, but I am missing a piece. Debbie -----Original Message----- From: Mark A Matte <markamatte at hotmail.com> Sent: Wednesday, November 05, 2008 1:31 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Excel link weirdness Debbie, I have some issues with importing numbers from excel. Excel will sometimes store a number as text...and Access won't import this into a number field. I just linked an excel file that I know has this issue...and had the result you described. The cells that stored my number as text showed as #!NUM# when viewed through the link in access. I believe if you check your spreadsheet you will find some numbers stored as text. Mark A. Matte > From: delam at zyterra.com> Date: Wed, 5 Nov 2008 12:48:30 -0600> To: accessd at databaseadvisors.com> Subject: [AccessD] Excel link weirdness> > I am linking an excel spreadsheet into an access database, both 2002. Some fields are not translating over to access at all and I cannot discover the reason. For instance one field is client/matter number and the values often repeat. The identical value will sometimes show up and other times be the #!NUM# I cannot interpret value.> > Any thoughts of some gotchas to look for? > > Debbie > > Debbie Elam> > -- > AccessD mailing list> AccessD at databaseadvisors.com> http://databaseadvisors.com/mailman/listinfo/accessd> Website: http://www.databaseadvisors.com _________________________________________________________________ Get 5 GB of storage with Windows Live Hotmail. http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_5gb_112008 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com