[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
>