PDA

View Full Version : how to start on line two with inporting



ennas
04-07-2006, 07:55 AM
I use this code for importing a textfile


Do While Not EOF(Txtfile)
Line Input #Txtfile, TXTLine
vData = Split(TXTLine, vbTab)
rst.AddNew



Extension = Trim$(vData(2))
Extension = Mid(Extension, 6)
rst![Extension] = Extension

Total_cost = Trim$(vData(5))
Total_cost = Mid(Total_cost, 1, 5)
rst![Total_cost] = Total_cost
rst![Date] = strdate_ono


Loop
Close #Txtfile


The code importing from line one, how can i make that the reading in start on line two

Post edited 10-Apr-06 by GeekGirlau. Reason: insert VBA tags

matthewspatrick
04-07-2006, 10:26 AM
Just put an extra Line Input in front of the Do, without actually doing anything with the input. That should get you to the second line.

Also, remember to use those VBA tags :)

geekgirlau
04-09-2006, 06:31 PM
Hi ennas,

When posting code, select all the code and click on the "VBA" button to place the tags around the code. I've edited your post so you can see what this looks like.