[AccessD] Excel Import

Yeah...tried that a few times.

:(

Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com

RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
21231-3305

410-537-6098 direct | 410-276-2136 fax | www.rtkl.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow
Sent: Monday, November 20, 2006 5:33 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Excel Import

Oh the joy of it, eh?

First thing I'd try is selecting all the empty rows and then deleting
them.
(just in case there's zero length string or something akin to that in
all of
them. Then try importing again.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Keith
Williamson
Sent: Monday, November 20, 2006 3:50 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Excel Import

Hey Guys,

I am trying to do an Excel import, into a new table.  There are 98 lines
of
data in my Excel file.  However, when I do my import....no matter what I
do,
it imports 64,963 records.  I have gone to the excel file and deleted
every
blank line, after my data.  But it still imports the same number of
records.
Why would it import all the empty fields??

Thanks,

Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com

RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
21231-3305

410-537-6098 direct | 410-276-2136 fax | www.rtkl.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