Import/Export Specifications - How to get to the saved specs.

  • Thread starter Thread starter LisaB
  • Start date Start date
L

LisaB

When you create an Import/Export Specification for a fixed width text file:

a)where does Access Put it.
b)How can you look at the saved specifications file.
c)What if you wanted to use the same specifications in another Access
database

** I want to be able to print out what the specifications are. or be able
to spit the specifications out to a table like this

Field Name Start Width
ConsultantID 1 11
FName 12 50
LName 62 50
SSN 112 15
Title 127 50
Ethnicity 177 50
CSAPAgreement 227 2
CSATAgreement 229 2
Active 231 2
ActiveNote 233 50
Notes 283 512
Resume 795 512
ResumeLink 1307 255
Degrees 1562 255
Licenses 1817 255
OtherPopulation 2072 155
OtherExpertise 2227 255
ADM Population 2482 150
RRPP population 2632 150
OtherStrengths 2782 255
AdditionalInfo 3037 512
Editor 3549 50
EditDate 3599 19
TEMPID 3618 11
 
A) The file specs are stored in two system tables: "MSysIMEXSpecs" and
"MSysIMEXColumns". You can view these tables by going to the Database
window and choosing Tools>Options and check the System Objects check box.

B) To look at a saved spec, you have to start to create a new one. Go to
File>Get External Data and choose a TEXT type import. When the Text Import
Wizard comes up, Click the Advanced button and on the box that pops up,
click the Specs button.

C) There are 2 ways:
1) From the database that you want to import the specs into:
Go to the Get External Data menu option. If you choose to import an
Access database, you will get a box to choose the various objects to import.
If you click the Tables tab, there is an "Options>>" button that opens the
form up more and reveals a check box that allows you to import all of the
specs from the other database. NOTE: imports ALL the specs
2) From the database that contains the specs you want:
With the System Objects showing, select MSysIMEXSpec and choose
File>Export. Choose the name of the database you want to send the table to
and click OK. NOTE: exports ALL the specs
3) If you want to just move one spec, you can create two append
queries, selecting just the records you want from one database and sending
them to the system tables in the other.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Back
Top