Hi
Does anyone know of an Add-in that will allow Access to process SQL directly from a text file? It would save the need to place the statements in literal strings within a VBA module.
I am thinking of a file similar to a MySQL Script. I am not asking for full MySQL compatibility, just the ability to write all my Access SQL statements in a single file in plain text and comment them properly.
I have written a program in VBA to do this and that has greatly improved my Access experience. But I wonder if there is a professionally developed product available?
Any advice gratefully appreciated.
Mark