Results 1 to 2 of 2
  1. #1
    Jackfam58 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2011
    Posts
    7

    Excel Import - File with row spaces

    Sample Data

    Changes to 2002



    Fee Amt Date

    125 2500 12/11/2001

    In this example, a space appears on line 1 so the data begins at line2.
    In some cases there is also a space between the headers and the data. Desired output is

    Fee Amt Date
    125 2500 12/11/2001

    I need a vba code or macro that can call a series of files in excel at a location and bring them into access. For example one file name might be
    in c:\myfiles\change_file_2001 There will be several files in the drive with all of them beginning with change_file the only difference might be the year. Any ideas on a simple script that handles the row spaces and starts with the actual column headers and skips the "Changes to 2002" etc

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    what have you tried so far?

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

Similar Threads

  1. Import Excel File Using Macro?
    By oregoncrete in forum Import/Export Data
    Replies: 0
    Last Post: 04-05-2011, 12:26 PM
  2. Import Excel file as report template - possible?
    By justinwright in forum Reports
    Replies: 2
    Last Post: 11-01-2010, 07:01 AM
  3. Splitting an Excel File into Multiple Access Tables on Import
    By TheWolfster in forum Import/Export Data
    Replies: 4
    Last Post: 04-29-2010, 04:52 AM
  4. VBA to open excel, import on close of excel
    By bdaniel in forum Programming
    Replies: 0
    Last Post: 03-20-2010, 02:45 PM
  5. Replies: 0
    Last Post: 04-29-2009, 04:27 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