I imported a file using the wizard. Just before "Finish", I clicked "Advanced" and saved the specification as "ProdSpec". Then I wrote the following code to call on it. The problem is that I do not want to import the first four lines of the file. Is there a way to tell it to start in row 4?
Private Sub Import_Click()
DoCmd.TransferText acImportDelim, "ProdSpec", "Prod", _
"C:\Program Files\SSM\001\Prod.txt"
End Sub
Thanks, Rick Ruscin
Private Sub Import_Click()
DoCmd.TransferText acImportDelim, "ProdSpec", "Prod", _
"C:\Program Files\SSM\001\Prod.txt"
End Sub
Thanks, Rick Ruscin