text file with headings throughout

  • Thread starter Thread starter Jim/Chris
  • Start date Start date
J

Jim/Chris

if the columns are lined up throught the text file the
unwanted infromation can be deleted with a delete query
after the import using one of the missing fields

Jim
-----Original Message-----
I have a text file to import into an access database.
However, throughout the file there are page and column
headings. Is there a way to get around them to import just
the data? Or do I have to go through the text and remove
them first? There are a lot! Thanks for any ideas.
 
Yes the column are lined up throughout. I'll give this a try. Thanks for the suggestion.
 
Back
Top