Where is the Import Spec file stored... 1

[Pack10]

Where is the import file specification file stored.
I built an import file spec a while ago but I can't seem to find where/how it can be edited. I have to show this to a co-worker and I forgot how I set it up.

Any help would be fantastic.

 

[dhookom]

There are a couple tables in Access that store import and export specifications: MSysIMEXSpecs and MSysIMEXColumns. You could write a query liked:

SELECT MSysIMEXSpecs.*
FROM MSysIMEXSpecs;

Duane
Hook'D on Access
MS Access MVP

 

[Hap007]

Hi Pack10,

I think I understand your problem.
If so, what you want to do is edit the Import Spec and can not find an Access Menu to get to the Specs.

In earlier versions of Access (version 2.0) it was easy, but not any more.

Several months ago, I had to do the same thing and here is how I was able to get to the Import/Export Specs using the Access UI:

To get to file Specifications:

To change either an import or Export, you must choose:
1) File > Get External Data > Import
2) File Type 'Text File'
3) Must pick a sample import file (Even if you desire to modify an Export Spec
4) Press 'IMPORT'
After you have data on screen
5) Select Advanced Button on Bottom Left
6) Then Pick 'Specs'
7) Pick the Spec you want
8) Make Changes
9) Save As and overwrite
Then, if all you wanted to do was modify an existing spec, just exit the import
10 ) Exit/Cance/Quit

If anyone knows a better way to get to the existing Specs, I would love to know that also.

But, this method does work.

Hope This Helps,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121