[AccessD] Import Specifications

Thanks, Jim....I think I might be able to use this.....Barb



----- Original Message ----- 
From: "Jim Moss" <jim.moss at jlmoss.net>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Friday, May 27, 2005 1:50 PM
Subject: Re: [AccessD] Import Specifications


> Barb,
>
> All that you really have to do is copy the MSysIMEXSpecs and
> MSysIMEXColumns tables from one database to another.
>
> Jim
>
>
> > Thanks, Jim....I'm familiar with that method, however, I am looking for
a
> > way to do it in VBA.  I have a VBA routine that I use to copy selected
> > objects from one database to another --- I just can't figure out the
> > import
> > specifications.   Barb
> >
> >
> >
> > ----- Original Message -----
> > From: "Jim Moss" <jim.moss at jlmoss.net>
> > To: "Access Developers discussion and problem solving"
> > <accessd at databaseadvisors.com>
> > Sent: Friday, May 27, 2005 1:30 PM
> > Subject: Re: [AccessD] Import Specifications
> >
> >
> >> Barb,
> >>
> >> I'm pretty sure that the Import Options were in place in Access 97.
What
> >> you do is open the receiving database and click File | Get External
Data
> >> |
> >> Import. Click on the donor database in the file open dialog, and then
> >> click on options which will expand the Import Options window. In the
> >> lower
> >> left corner you should see an option under Import for Import/Export
> >> Specs.
> >> Just check the checkbox and click OK.
> >>
> >>
> >> Jim
> >>
> >>
> >>
> >> > In Access 97, is there a way to programmatically (i.e., VBA) copy
> >> import
> >> > specifications from one database to another?  Are they stored in some
> > kind
> >> > of collection (e.g., like the Containers collection)?
> >> >
> >> > Thanks,
> >> > Barb Ryan
> >> > --
> >> > 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
> >
> > --
> > 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