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