Keith Williamson
Kwilliamson at RTKL.com
Mon Nov 20 17:01:25 CST 2006
Thanks. This worked. Although, for an ongoing process...I can just see me forgetting to re-define my range...and not uploading all the proper data. :( For now, however...this worked. :) 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 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of McGillivray, Don [IT] Sent: Monday, November 20, 2006 5:01 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Excel Import 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com