[AccessD] Subject: Re: Eliminating lines of text before importing

Mark:

I experimented with this after I posted the message, before receiving any 
answers, and ended up importing and then running a delete query (with null 
for the blank lines, and also deleting some other unwanted lines - e.g., 
totals - that I didn't want to import). I had thought Access would mess up 
the import, since a blank line has no fields (duh), but I created an 
import spec and had Access use that, and it did just fine.

I'd still like to learn how to do it the other way, though, just for my 
own knowledge's sake.

Thomas F. Ewald
Stryker Mass Properties
General Dynamics Land Systems


Message: 8
Date: Fri, 26 Oct 2007 14:11:55 +0000
From: Mark A Matte <markamatte at hotmail.com>
Subject: Re: [AccessD] Eliminating lines of text before importing
To: Access Developers discussion and problem solving
                 <accessd at databaseadvisors.com>
Message-ID: <BAY127-W287B946A3E9CE42A8A35A8D2960 at phx.gbl>
Content-Type: text/plain; charset="iso-8859-1"


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.  



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.