I have a form in Access 2010 that runs the following line of code when a button is pressed:
DoCmd.TransferText acExportDelim, "mySpecs", "myQueryName", "C:\myFileName.txt", False
I wish to use Excel and perform this same exact functionality using VBA within Excel.
I am able to run the query and have the output in Excel just fine, but I need to use the specs that are saved within the database. Any ideas?