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

[Stuart McLachlan]

You can't edit saved import/export specs because of the way they are stored.  :(

Look in MSysAccessStorage 
Find the entry named ImExSpecs
Note ID. Now filter ParentID for that number
Note the IDs of the filtered object with names 0,1,2 etc
Now filter for those in ParentID.
You will find objects named BLOB. 
The Lv field for those records (Long Binary Data" is an OLE Object. That object contains the 
export spec.
Those objects are stored in the same way as all the other "LongBinary Data" objects in the  
database (i.e. the *compiled* forms, reports, modules). 

IOW, there's no way to access and edit them, any more that you can edit a form in a 
compiled accde :(


On 6 Aug 2021 at 15:59, Borge Hansen 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
>