• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 345
  • Last Modified:

TransferText Argument

I want to figure out what the specifications of "Specification BJU" included in this line of code.  Where do I find this?

DoCmd.TransferText acImportFixed, "Specification BJU", tempTable, strPathNoExt & ".txt", yes

When I look in the help it indicates that the argument is called a "SpecificationName" Help mentions this:

A string expression that's the name of an import or export specification you've created and saved in the current database. For a fixed-width text file, you must either specify an argument or use a schema.ini file, which must be stored in the same folder as the imported, linked, or exported text file. To create a schema file, you can use the text import/export wizard to create the file. For delimited text files and Microsoft Word mail merge data files, you can leave this argument blank to select the default import/export specifications.

Any idea where I'd start looking for "Specification BJU"?  Is it a seperate file? Is it a setting in Access itself? HELP!
0
gcgcit
Asked:
gcgcit
  • 5
  • 4
1 Solution
 
Rey Obrero (Capricorn1)Commented:
the specification was created when an export was done manually.

you can inspect the specfication by,
select the table, File > export, follow the instruction

in the import/export wizard form, click the Advanced button
click Specs..
select the name  from the list and click Open
0
 
Rey Obrero (Capricorn1)Commented:
an specification can also be imported from another db.
the specification are listed in table msysImexSpecs and details are in msysImexColumns
0
 
gcgcitAuthor Commented:
Where do I find the "import/export wizard form"?
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Rey Obrero (Capricorn1)Commented:
if you read my first post, you have to do a manual exporting first.
0
 
gcgcitAuthor Commented:
I followed your instructions above.

I selected to table, pressed File > Export

a dialog box opened up to select a database to export... there are no follow the instruction

I'm stuck.
0
 
gcgcitAuthor Commented:
I made an empty database to then export the table into... but again... I'm not sure what the steps are above that I need to do to see an Advance Button and see specs.  Please provide more detailed steps or a screenshot of what I'm looking for.  Thanks in advance.
0
 
Rey Obrero (Capricorn1)Commented:
selected to table, pressed File > Export

from the dialog window, select TextFiles  from the Save as Type dropdown box
then click export
0
 
Rey Obrero (Capricorn1)Commented:
see this link

How to Create and Save Data Export Specifications
http://support.microsoft.com/?kbid=209740
0
 
gcgcitAuthor Commented:
Ok found it with those additional steps you provided - thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now