Solved

Where can I find Export Specifications

Posted on 2006-11-16
2
950 Views
Last Modified: 2008-03-03
Hello All;

TIA for your help.

I have an Access application that uses a macro to export data.
The macro action is Transfer Text, the transfer type is Export Delimited
In the Specification Name field is the name of a specification.
I did not create this macro so I don't know what the specification is.
How can I view this specification or edit it? How is it created in the first place?
I can not find the specification name anywhere. It is not a table or query or file.

Thanks

Bob
0
Comment
Question by:Rwardlow
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 66

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 17956709
This may sound bass-ackwards, but you'll need to treat this as an Import Spec to get there.

File : Get External Data: Import, select your .txt file, Next button, click on Advanced button in lower left corner.

Edit the Inport Spec the way you wish, save, then just refer to it in your export.
0
 
LVL 9

Expert Comment

by:dancebert
ID: 17957020
File : Get External Data: Import, select ANY .txt file, Next button, click on Advanced button in lower left corner.

Then click the Specs button.  A dialog box opens showing the existing import and export specs.  Select the one named in your code, then click Open.  You'll be back at the screen that shows Field Names, Data type, Start column and Width (# columns) for each field defined in the spec.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

734 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