specificationname

[Bob Fortune]

I am trying to export a qry to a Text File my problem in my example i get
error msg requesting a specificatioin name ." Where do Get this From ? my
code is as follows
DoCmd.transfertext transfertype; =acExportDelim, _
Specificationname:="contactHomeqry export specification", _
TableName:"qryHomePhone", _
FileName:="C:AccessLinks\HomePhone.txt, _
hasfieldnames:= True
Any assistance would be very much appreciated
Bob Fortune

 

[Tom Wickerath]

Hi Bob,

When this export routine was first written, the database likely contained an
import/export specification named "contactHomeqry export specification"
(otherwise it would have never worked). I'm just guessing, but it sounds like
you may have imported this code from another database? If so, use:

File > Get External Data > Import...

Navigate to the source database. Click on the button labelled "Options >>".
Place a check mark in the box that reads "Import/Export Specs".


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Bob Fortune]

Thank you Tom for replying so quick. I think you are on the right track,
however not able to inport from another db as the code was devised by
following the help when i used a Command button . DoCmd.TransferText and
tried to work out what was required . How are Specficationname stored and can
they be accessed or new ones entered

 

[Tom Wickerath]

Hi Bob,

Specifications are stored in a hidden system table named MSysIMEXSpecs. To
create an Export specification, use this KB article as a guide:

ACC2000: How to Create and Save Data Export Specifications
http://support.microsoft.com/?id=209740

Don't pay any attention to the "ACC2000" in the title--this should work just
as well for later versions of Access (and likely Access 97 as well).

To see a step-by-step tutorial that I provided last November, see this link:
http://groups.google.com/group/micr..._frm/thread/bf0f343a54228b6a/3c30e776c4942bd5


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Bob Fortune]

Tom Many thanks after i got my head round the problem and followed the
instructions you provided i can now create my export spectifications. Thanks
again for your time