MS Access 2003 Import Filename Limitations?

[whdyck]

I'm using Access 2003.

I have a TransferText command that works fine, as follows:

DoCmd.TransferText acImportDelim, "LiaImportSpecification", "tblLiaSourceImport", "H:\SmartSoft\SsLogistics\CSVInput\lia.csv", False

However, if I copy the lia.csv file as LIA.20120819.211726.csv and substitute this new filename into the code, I get a runtime error "type mismatch":

DoCmd.TransferText acImportDelim, "LiaImportSpecification", "tblLiaSourceImport", "H:\SmartSoft\SsLogistics\CSVInput\LIA.20120819.211726.csv", False

So does Access 2003 have problems dealing with long filenames?

Thanks for your help.

Wayne

 

[boblarson]

Long file names are not a problem but file names with multiple periods it does have a problem with.