jwcolby
jwcolby at colbyconsulting.com
Fri Oct 26 08:21:47 CDT 2007
I do it by opening a file for input and a file for output, read line by line, count 65 lines, then start writing out to the output file on line 66. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of ewaldt at gdls.com Sent: Friday, October 26, 2007 7:29 AM To: accessd at databaseadvisors.com Subject: [AccessD] Eliminating lines of text before importing I have a semicolon-delimited text file coming in from another operating system. The data I want to import begins on line 66. How can I tell Access to either delete the first 65 lines before importing the data, or just start importing on line 66? At this point the user has to delete the first 65 lines manually, but I'd like to automate this. I have Access 2002 (XP), and am using VBA, of course. TIA. Thomas F. Ewald Stryker Mass Properties General Dynamics Land Systems This is an e-mail from General Dynamics Land Systems. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com