Writing excel code into excel (or duplicating excel sheets)

@Andrew_Hannell so the workflow would be like after using “Command.SQLite_Command” for example. Open it with MS Access then to Excel correct? Which method would be best for the import…just the “Excel.ReadFromFile”?


Sorry, I’m not quite with you (and the thread has meandered around a few topics/ideas)
Where does the ExcelReadFromFile come into it ?

It shouldn’t be necessary to open Access (or whatever database is used)
Excel can dynamically link to the data, and just gets refreshed

Oh! that last part helped catch what was flying over my head. (slap palm to forehead moment)