[AccessD] Access 365 Saved Exports where are the specs??

jack drawbridge jackandpat.d at gmail.com
Fri Aug 6 06:46:50 CDT 2021

See info here for ideas. View Edit Imex

On Fri, Aug 6, 2021 at 1:59 AM Borge Hansen <pcs.accessd at gmail.com> wrote:

> Hello everyone,
> I have several saved Export specifications that exports various select
> queries to Excel.
> The exported excel file name is based on the name of the query.
> If the excel file name exists from before, the export creates a new
> worksheet in the file.
> All exports work fine - all is good.
> BUT where can I find the actual export specification for each of these
> exports?
> For example - the current exports all go to a folder in our R:\ drive
> If I want to change this to another folder or another drive - where
> can I do that?
> So far no luck on google!
> suggestion by Crystal  on 10FEB2016 on
> https://access.uservoice.com/forums/319956-access-desktop-application/suggestions/11127225-import-export-specs-edit-feature
> The tables that store import/export specs are:
> MsysIMEXspecs
> MsysIMEXcolumns
> While you cannot modify the tables directly, you can use APPEND
> queries to add records to those tables -- and you can delete records
> from them directly. You can probably use UPDATE queries on them too,
> but what I usually do is
> 1. make-table from the columns of a spec using MsysIMEXcolumns
> 2. delete rows from MsysIMEXcolumns for a particular spec
> 3. modify specs
> 4. use APPEND query to write records back to MsysIMEXcolumns for a
> particular spec
> I followed the suggestion here, but the value in the two Msys tables
> only relates to one export and stays the same after running various
> exports - so, I think the actual specs are kept somewhere else.
> Any one?
> /borge
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

More information about the AccessD mailing list