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