[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