exporting an access specification - Xtreme Visual Basic Talk

11-22-2006, 08:32 AM

icampbell

Junior Contributor

Join Date: Feb 2003

Location: Northumberland, England

Posts: 236

exporting an access specification

Does anyone know how to export an access transfertext specification.
I have a db that imports a text file on the click of a macro using the transfertext option.
it uses a specification name of 'ICNewImport' to put the fields into the correct order and renames them.

What i want to know is, can i export the specification (file, if it is one ?) to another database.
I cannot see where the specification is stored.

Thanks in advance

Ian.

__________________
Were all going to heaven lads, wey heyy.....

11-22-2006, 08:52 AM

Timbo

Green-Eyed

Super Moderator
* Guru *

Join Date: May 2001

Location: Bangkok, Thailand

Posts: 10,261

In the new database, use the menu option 'File > Get External Data > Import...' to select the database containing the IMEX spec. Then use the 'Options' button on the wizard that appears, to reveal the "Import" group. Select the 'Import/Export Specs' and hit "Ok".

__________________
"He's not the Messiah. He's a very naughty boy!" - Brian's mum

Can't find the answer? >> Try something new!
Become a Professional

11-22-2006, 09:01 AM