Export Spec

  • Thread starter Thread starter Shannon
  • Start date Start date
S

Shannon

Where does Access save the file that is created and
called filenameExportSpec, when you are transfering text
in a macro? We have not been able to find this file so it
can be deleted. Thank you.
 
Shannon,

The information stored in Import/Export specifications pertaining to field
names, types, sizes, start/end position etc. is not stored in self-contained
files; it is stored within the Access database, in two system tables,
MSysIMEXSpecs for the spec header data and MSysIMEXColumns for the columns
data.
These tables can be viewed if you select to make system objects visisble
(Tools > Options), but you cannot manually change the tables. The only way
to create / change / delete specs is through the import/export wizard.

HTH,
Nikos
 
Back
Top