Heenan, Lambert
Lambert.Heenan at chartisinsurance.com
Tue Nov 1 15:16:39 CDT 2011
I agree about the probable difficulty of modify the specs, but it's simple enough to do it manually. Just start a manual import as usual, select the import spec you want to modify, which does most of the hard work for you, and then make changes to it as needed. Finally save it with a different name with the 'Save As' button on the Import Specification dialog box. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Patten Sent: Tuesday, November 01, 2011 3:30 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Import/Export Specifications - Basic questions Brad, The specs are located in system files MSysIMEXSpecs and MSysIMEXColumns. Since they are tables I suppose you can modify them but probably not easy and you may not be able to write to system files. The name of export Specs is located in the XSpecs table and the ID assigned, then the column definitions and spacing are in the XColumns table by ID number. I think if you look at them you will be able to easily identify what is going on. The ability to show how to un hide them is cleverly hidden by right clicking on the top of the Navigation page and selecting Navigation options. HTH Bill -------------------------------------------------- From: "Brad Marks" <BradM at blackforestltd.com> Sent: Tuesday, November 01, 2011 12:00 PM To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Subject: [AccessD] Import/Export Specifications - Basic questions All, I have a couple questions about Import/Export Specifications (Access 2007). Once a specification is set up, is there a way to change the spec other than making believe that you are setting up a new spec? Also, is it possible to get at the spec with VBA code? Thanks, Brad -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com