[AccessD] Import Wizard Import/Export Specs

Thanks Gary and Jeff!

I can see and open the two system tables MSysIMEXColumns and MSysIMEXSpecs.
And as Gary says the former has the field headers and the later has the
field details. What I was trying to find (and edit) was the name of the
table that the spec saves the imported data as. 

A very minor problem really, but just something I was trying to sort out.

Thanks for any help/guidance/assistance.

Chris Foote

> -----Original Message-----
> From: Gary Kjos [mailto:garykjos at hotmail.com]
> Sent: Tuesday, October 28, 2003 7:08 PM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Import Wizard Import/Export Specs
> 
> 
> They are in a couple hidden/system tables. Go into Options and select 
> Display on Hidden and System tables and you will see them - 
> in a database 
> that HAS at least one. There is one table for the Spec 
> Headers and another 
> for the field detail. I think you can read them but not write 
> to them. You 
> can use them in queries.
> 
> Gary Kjos
> garykjos at hotmail.com
> 
> >From: "Foote, Chris" <Chris.Foote at uk.thalesgroup.com>
> >Reply-To: Access Developers discussion and problem 
> >solving<accessd at databaseadvisors.com>
> >To: "'Access Developers discussion and problem solving'" 
> ><accessd at databaseadvisors.com>
> >Subject: [AccessD] Import Wizard Import/Export Specs
> >Date: Tue, 28 Oct 2003 16:20:25 -0000
> >
> >Hello,
> >
> >any idea where/how A97 stores it's Import Wizard Import/Export specs?
> >
> >TIA - Chris Foote