VBA to refresh linked text files

[ashley25]

This has probably been covered, but I am looking for some code that will refresh a set of linked text files, and then run the queries associated to these files automatically. I can do the last part, but its the refresh I need help with.

 

[thechazm]

Is the text files delimited by anything? A comma or a semicolon, etc...?

 

[ashley25]

yes the files are delimited by a comma

 

[thechazm]

Why do you need the text files linked? Is their a specific need or are you just needing to read the file everytime someone opens it? Also are you wanting to update the text file from within access or is that done manually by something else?

Please provide additional info.