How to not import the headers of a text file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have these text files that I get every week and I need to Import them into
Access to save my Importing Specs. My problem is that these Text files have
headers and footers that I don't need. I just want to Import the data.
 
Hi Michael,

If you know how many lines there are in the header, there's a VBA
function here
http://www.j.nurick.dial.pipex.com/Code/VBA/TrimFileHeader.htm that will
remove them for you.

Footers are usually less of a problem: if the validation rules on your
table don't prevent them being imported in the first place, it's usually
easy to construct a delete query that will get rid of them. But the same
page has a link to a Perl script which chops off footer lines as well as
header ones.



On Wed, 18 Jan 2006 08:59:17 -0800, Michael Russell <Michael
 
Back
Top