?
Solved

TransferText Argument

Posted on 2011-04-26
9
Medium Priority
?
343 Views
Last Modified: 2012-06-21
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
Comment
Question by:gcgcit
  • 5
  • 4
9 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35467847
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
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35467870
an specification can also be imported from another db.
the specification are listed in table msysImexSpecs and details are in msysImexColumns
0
 

Author Comment

by:gcgcit
ID: 35468448
Where do I find the "import/export wizard form"?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35468510
if you read my first post, you have to do a manual exporting first.
0
 

Author Comment

by:gcgcit
ID: 35468571
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
 

Author Comment

by:gcgcit
ID: 35468608
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
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 35468658
selected to table, pressed File > Export

from the dialog window, select TextFiles  from the Save as Type dropdown box
then click export
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35468839
see this link

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

Author Comment

by:gcgcit
ID: 35468951
Ok found it with those additional steps you provided - thanks!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question