Microsoft Access - I have csv files to import into a single table.i want to get rid of the 1st 3 rows in csv.

Asked By shekhar on 06-Nov-12 06:35 AM
I have several CSV files that i need to import into a access table.  I would be appending each one by one in one single table.  I have set the fields in the table to match that of csv files. I have 1st three rows in each csv file, that i do not want to append ,rather want to get those deleted before it is imported into the table.

Is there a automatic way to delete the 1st 3 rows of csv's and then append the data to the table? no big macros please. easy simple way as i am still learning access.

thanks
shekhar
Pat Hartman replied to shekhar on 30-Dec-12 06:19 PM
If there is some way to identify those three rows short of their ordinal position, you can eliminate them by using criteria in the append query.  If you can't eliminate them with criteria, append the csv files to a temp table.  Add an autonumber.  Then in the append query select rows with an autonumber value > 3.