[AccessD] Excel Import

McGillivray, Don [IT] Donald.A.McGillivray at sprint.com
Mon Nov 20 16:00:46 CST 2006


Hi, Keith

I can't say that I've seen that behavior before, but Access seems to be seeing the entire Excel sheet as the data source when you do the import.  Try naming the range (Insert/Name) of the Excel sheet that holds the data.  Then specify that named range for import into your table.  Named ranges are very useful both within Excel and for this sort of external task.

Hope this helps!

Don McGillivray

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Keith Williamson
Sent: Monday, November 20, 2006 1: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





More information about the AccessD mailing list