Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Import File Starting in line 4

Status
Not open for further replies.

SeaRay

Technical User
Jan 8, 2002
20
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top