[AccessD] Excel Import

Record #99 and on, are nothing but blank records.  Actually, I did copy
this data in from a html screen version of excel...into a blank excel
worksheet.  Then uploaded that. 

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 Susan Harkins
Sent: Monday, November 20, 2006 5:08 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Excel Import

Keith, is it importing each cell entry as a single record or are the
records
pretty much intact? If the latter, what's in rows 99 and beyond? 

The first thing I'd suggest is that you copy the 98 records into a clean
sheet and just get rid of the old one. 

Susan H. 

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


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