[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