Import .csv get runtime error 31519 you can't import this file

[kpal29]

I have an .csv file and am trying to import it into my Access DB. Nothing fancy just a simple import in VB. I can import manually using same spec into same table with no error but when I use the code I get the runtime error. Pls help this is driving me crazy.

my code:
Sub New_Vol_Import()
Dim File As String
File = Forms!FileImport.Directory
DoCmd.TransferText acImportDelim, , "JobProdVol_200608222346", File
End Sub

 

[PHV]

Your code doesn't provide any SpecificationName ?
Does Forms!FileImport.Directory contain a pathname with a legal extension for import ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886