Import csv file into Access table 1

[LD1010]

I receive a csv(comma delimited) file each day that needs to be importated into Access. I've tried the following code but can't seem to make it work.

Private Sub Img1_Click()

DoCmd.TransferText , acImportDelim, "tblFLIFOlog", _
"C:\Documents and Settings\remote\Desktop\FLIFO\FLIFOmonitorReport2.csv", -1

End Sub

I'd appreciate any help in learning how to do this. Thanks in advance.

 

[PHV]

What about this ?
DoCmd.TransferText acImportDelim, , "tblFLIFOlog", _
"C:\Documents and Settings\remote\Desktop\FLIFO\FLIFOmonitorReport2.csv", -1

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[LD1010]

Thanks again PHV!! That's twice this weekend you've helped me out. Given enough time and help I may actually learn to get by in VBA. Have a great Easter!