Link to home
Start Free TrialLog in
Avatar of vbnetcoder
vbnetcoder

asked on

Import Spec: How do i get my import spec to ignore header rows

In my import spec it is attempting to insert header rows.  I can i ignore them?
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

you set the option to false in the command line

DoCmd.TransferText acImportFixed, "ImportSpecificationName", "myTableName", "C:\myTextr.txt",FALSE
if you are using delimited files

DoCmd.TransferText acImportdelim, "ImportSpecificationName", "myTableName", "C:\myTextr.txt",FALSE
Avatar of vbnetcoder
vbnetcoder

ASKER

Can't I do it in the spec itself?
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ty