Import File with special characters

[ryand09]

Hello

I've got a number of files exported from other systems that I need to import back into Access, the files have full stops in the file name. How can I get round these issues and Import. e.g. file names ...

2016.01.14.myFile.csv
2015.12.01. myFIle.txt.01_12_2014_14_47.csv

Thanks in Advance
Ryan

 

[Frothingslosh]

Precisely what errors are you encountering? There shouldn't be an issue with spaces, underscores, and extra spaces.

 

[ryand09]

Thanks for getting back to me. I'm getting an error that the files cannot be found, if I rename them and take out the . (dots's) it works. I think I just need some sort of mask, but I can't figure it right now???

Thanks.

 

[Frothingslosh]

Please post the code that's generating the error. Preferably the whole function.

If you can, use the code tags - that keeps your formatting, allowing it to be read more easily.