TransferText CSV Import - Can't import open files (1 Viewer)

[N1029676]

I have a database which will search a directory and all of its sub-directories for CSV files matching a certain format (60+ files at a time) and import them into a table to be processed later. These CSV files are generally created and then opened by multiple users for analysis.

My current issue: I'm unable to import open CSV files because they are locked by individual users and access appears unable to open the file as read-only.

How can I have transfertext open and read the file whether it is opened or not?

I'm trying to avoid searching for the CSV files and copying/pasting into one folder and going from there. After searching MSDN, ms Help, and a broad google search. Any ideas?

Thanks
-Tim

 

[N1029676]

Nothing?

That sucks...

 

[spikepl]

If the files were read-only in the first place, perhaps TransferText would be able to open them - you could run a quick test.

If that fails, you could open the file, read and parse the records yourself , using the OPen or perhaps the filesystemobject http://vbadud.blogspot.com/2007/06/vba-read-text-files-with-leading.html