Import/export specs edit feature
Currently, the developer needs to go through the process of importing a file into a database in order to create or edit an import/export spec in the MSysIMEXSpecs table. True, the MSysIMEXColumns can be edited directly in the table, but overall, the process is not very user friendly. There needs to be functionality to create/edit import/export specs without have to pretend that one is importing an external file.
Jacqui Evanchik commented
Yes. And once a saved import/export is created, we need a way to EDIT it (not just the name or description, I mean the spec). Sometimes these are pretty complex and then something simple like a table name changes, and we need to create it all over again starting from scratch (what if I can remember)! And it would be great to be able to call these from vba.
The tables that store import/export specs are:
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
Andy Rice commented
I would really like this, too. I use a lot of import/export specifications.
Ananda Sim commented
This proposal overlaps "Import From Excel" proposal