[AccessD] Eliminating lines of text before importing

I have a DB that imports a text file where every other line is blank.  I just run a delete query AFTER the import...to remove the unwanted rows.  
 
Another aproach would be to open the file for input and output and remove lines you don't want.
 
Will the file import without deleting the unwanted rows (as is)?
 
Thanks,
 
Mark A. Matte
 
> To: accessd at databaseadvisors.com> From: ewaldt at gdls.com> Date: Fri, 26 Oct 2007 07:28:33 -0400> 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
_________________________________________________________________
Help yourself to FREE treats served up daily at the Messenger Café. Stop by today.
http://www.cafemessenger.com/info/info_sweetstuff2.html?ocid=TXT_TAGLM_OctWLtagline