Currently i have a table in access which is created, data is added (both usng SQL), the table is exported to Excel (using DoCmd.TransferSpreadsheet), then the table is deleted (using SQL).

Presently the output path is hard coded as "C:\" for testing, however if i try to read the export path from an external .ini file the app hangs on the line of code which executes the "SELECT... INTO..." SQL statement.... any ideas?

Chris