[AccessD] Excel link weirdness

I redid all titles to avoid all but alpha numeric values.  I do not see any differences in the valuex that did show up, vs those that had not.  They were in the same column.

Debbie 

-----Original Message-----
From: Max Wanadoo <max.wanadoo at gmail.com>
Sent: Wednesday, November 05, 2008 12:55 PM
To: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Excel link weirdness

My thoughts are the "/".  I know that if I put a "-" (minus) in the
title/header of a column then Access treats it as if I am saying "A minus B"
when all I want is A-B.  Change the column heading to avoid spaces and
non-alpha characters.

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Debbie Elam
Sent: 05 November 2008 18:49
To: 'Access Developers discussion and problem solving'
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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com