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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Export Gmail Emails to PST Format? 4
Export data macro 1
Tab delimited export doesn't work 2
Import .xml with a macro 4
How can I migrate MBOX to PST? 2
Access Access variable string for export 0
Export Spec Problem 1
Which is the best MBOX Converter Tool different formats conversion? 4

Back
Top