How do you print an import specification?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JLR_2worldpeace - 15 Jun 2007 14:36 GMT

I created and saved an import specification. I want to print this
specification out as my "file layout" document. Can I print it or cut/paste
into another document?

Reply to this Message

Roger Carlson - 15 Jun 2007 14:59 GMT

The following query:

SELECT MSysIMEXColumns.*, MSysIMEXSpecs.SpecName
FROM MSysIMEXColumns INNER JOIN MSysIMEXSpecs ON MSysIMEXColumns.SpecID =
MSysIMEXSpecs.SpecID
WHERE (((MSysIMEXSpecs.SpecName)="My Import Specification"));

will list the specifics of your Import Spec. Just replace "My Import
Specification" with the name of your own spec.

Signature

--Roger Carlson
MS Access MVP
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

>I created and saved an import specification. I want to print this
> specification out as my "file layout" document. Can I print it or
> cut/paste
> into another document?

Reply to this Message

JLR_2worldpeace - 15 Jun 2007 15:24 GMT

Thank you for the reply. In the meantime, I found a less technical way to
get what I needed. I highlighted all information in the field information
display on the import specifications window. Then I used <control-C> to
copy, opened excel, and pasted <control-V> the file layout into excel. This
gave me exactly what I needed. Although the copy/paste options are not
available on pop up menu or tool bar menu, they are allowed with keyboard
comands of copy/paste. Thank you again for taking the time to respond to my
request. It is much appreciated.

> The following query:
>
[quoted text clipped - 10 lines]
> > cut/paste
> > into another document?

Reply to this Message