[AccessD] Excel link weirdness

Max Wanadoo max.wanadoo at gmail.com
Wed Nov 5 14:32:50 CST 2008


Have you tried the Wizard for importing or are you using the
docmd.transferspreadsheet code?
If the former, try telling it that the first row is NOT headers and see what
happens.

If the latter, try using the various optional values for import and see what
happens for each one.

Max


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



-- 
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