Importing portions of text files

[Kila]

I am trying to write a macro that will import a text file. We download reports from another incompatible program to text files that consistently have the same number of irrelevant leading lines at the top. I want the program to ignore the first four lines (or records, if they were successfully imported) and only import the lines of data after that.

What would be the easiest way? I am designing a database to store the data, and I want it to be very easy for non-access users to use. (i.e., push a button, file is imported, end of story) Thanks in advance for any help you can offer.

 

[Rich]

posting under more than one topic isn't likely to get a quicker answer
http://www.access-programmers.co.uk/forums/showthread.php?t=63357

 

[Kila]

Sorry!

I'm sorry. Since no one had replied, I was thinking that I had not posted to the correct forum. I have been working on the problem at this end and it occurred to me that this forum was actually the more appropriate one. I thought that the folks who review THIS forum might not see the posting on the other one. Sorry for any confusion.

posting under more than one topic isn't likely to get a quicker answer
http://www.access-programmers.co.uk/forums/showthread.php?t=63357