Import Specification File

  • Thread starter Thread starter Cindy
  • Start date Start date
C

Cindy

I'm working on a database created by another programmer
and he created an import specification file used to
automate the import of a .csv file. How do I get to this
specification file? I looked in help and it said an *.ini
file should reside in the same folder as the import file
but I don't have that file. Any ideas?

Thanks!

Cindy
 
Cindy:
Click File, Get External Data, Import
Select the CSV file you wish to import and enter
Click Advanced..., then click Specs...
There should be a list of the specifications he created.

Ray
 
Hi Cindy,

You may already know this, but you can access the specs
by starting the import of a text file (File|Transfer
Text|Import...), then click the advanced button and the
specs button to see a list of existing specs. Specs can
also be imported into other databases by clicking the
options button (I'm pretty sure that's the button name)
and selecting import specifications.

But, if you want to also see the specs in table format,
display the system tables by going to Tools|Options and
under View select System Objects. The import
specifications are stored in the MSysIMEXSpecs and
MSysIMEXColumns tables. I have also seen some posts that
the info is stored in a different format in the
schema.ini file, but I have never looked into that.

Hope that helps.

-Ted Allen
 
Back
Top