[AccessD] Import Specifications

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