import specification /transfertext location?

[dumdum2]

Hi,

I have a macro in one Access 2000 database that I copied to another. In the macro, the TransferText command is used and I saved an import specification name, so the import is handled the same every run.

Where can I find the import specification that I saved to copy it to the new database......?

Thanks!

 

[PHV]

Expand the Options of the import wizard and tick the import/export specifications.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dumdum2]

thanks, but the previously defined specs are not listed there.....

anyways, i found some help on microsoft would you believe.....

http://support.microsoft.com/default.aspx?scid=kb;en-us;208991

 

[wotgoesup]

I had a related issue -- I wanted to create import specs from existing Excel record layouts, without having to retype names, displacements etc.
Let's say you want to create a spec for a file "newdata", for which you have a spreadsheet with names, start pos and lengths.
Process:
1. Read the Microsoft bulletin prev mentioned.
2. Open the MSysIMEXSpecs table, and create a new rec, by copying an existing rec. Note the SpecID # has bumped up, and change the SpecName to "newdata". Exit (save)
3. Open MSysIMEXColumns, and copy the headings and a few records from an existing spec - pref close to what you want.Paste these rows into a new Excel sheet.
4. Copy the field names from the spreadsheet of "newdata" into the FieldName column. Copy the start positions into the Start col. and the field sizes into the Width col.
5. Copy the data in the other cols into all rows now populated by the "newdata" fieldnames, but use the new SpecID #.
6. Check what you have makes sense -- lengths, etc. and NO duplicate fieldnames.
7. As a precaution, select only those cells you have used, and create a new book by pasting. Save this.
8. Go back to Access and "get external data" / "import" / the spreadsheet you just created, First row with headings, into "existing table" MSysIMEXColumns .

Now when you need to import data that matches the "newdata" spec, just select it from the "advanced" / "specs".