I have a simple script that attempts to process SQL and .csv data into Access tables linked to Excel 2013 templates which have the data tables/queries linked but are refreshed by the script. Can all be done with Access Modules, but the sheer number of reports makes a compiled script work. All is well except for one issue:
I get .csv data from a VDI where I have limited access and must use a web service to transmit .csv files to my local drive where they are saved. With an Access macro I can use DoCmd() with Saved Import specs - but in order to use WB have to resort to ADO INSERT INTO SQL... All is fine except the .csv files are saved as UTF-8 which is not recognized by the Ace Provider text driver - only ANSI.
So, probably a simple answer but would like a FileGet() .... FilePut() that would re-save the .csv as ANSI once exported from email.