[AccessD] Excel link weirdness

Susan Harkins ssharkins at gmail.com
Wed Nov 5 14:31:18 CST 2008


<http://articles.techrepublic.com.com/5100-10878_11-5276622.html>

Debbie, I don't know if you'll find any help, but thought I'd share this one 
just in case.

Susan H.


> 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
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com 




More information about the AccessD mailing list