vba - Skip first three lines of CSV file (using DoCmd?) in MS Access

Question

I need to skip the first three lines of a CSV file when loading into MS Access. The default CSV import does not drop the first three lines. I am thinking of writing a macro to ignore the first three lines.

My research has shown the DoCmd object but its methods do not cater to drop the first x lines.

Any thoughts?

Answer 1

The DoCmd.TransferText method takes a SpecificationName as one of its arguments. Follow the instructions at How to Create an Import Specification to create and save an import specification.

Now go into Access Options, Navigation Options, and show hidden/system objects. You should now be able to open a table named 'mSysIMEXSpecs'. Find the import spec you created earlier based on the SpecName column. Change the 'StartRow' column for that import spec to 3 (the StartRow is zero-based).

Now you should be able to use the DoCmd.TransferText method passing the name of the import spec you created and it will skip your first three lines.