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
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