[AccessD] Eliminating lines of text before importing

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




More information about the AccessD mailing list