Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Posts
    16

    Skipping headers when Importing a text file.

    I have a file that I want to import into an Access database, but I would like to start the import at the third line as the first two lines are header information and other garbage.

    The file format is fixed width aned outside of the first two lines, I want to import everything.

    Is there an option to tell the import specification to skip the first two lines?



    Thanks.

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    if there isn't an option to do it in the wizard, an alternative would be to import through code and to follow up with a few extra lines that delete the top two rows out via the recordset object or via a DELETE query/action command (may need to combine the qry with a function if row identification is difficult through actual values)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. importing data from csv file
    By sbglobal in forum Import/Export Data
    Replies: 2
    Last Post: 08-22-2010, 11:45 AM
  2. Import to text - only text value NOT importing
    By Gerry in forum Import/Export Data
    Replies: 10
    Last Post: 03-26-2010, 06:55 AM
  3. Importing text file into Access Table
    By Anthony in forum Import/Export Data
    Replies: 13
    Last Post: 09-23-2009, 04:47 PM
  4. Importing Txt file via Vb
    By jquickuk in forum Import/Export Data
    Replies: 1
    Last Post: 04-01-2009, 08:27 AM
  5. Importing file into Access
    By jquickuk in forum Import/Export Data
    Replies: 1
    Last Post: 03-23-2009, 09:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums