Solved

DoCmd.TransferText - What is "SpecificationName"?

Posted on 2003-10-31
4
2,615 Views
Last Modified: 2010-08-05
specificationname      A string expression that's the name of an import or export specification you've created and saved in the current database.
This argument is required for fixed-width text files. For delimited text files and Microsoft Word mail merge data files, you can leave this argument blank to select the default import/export specifications.
*********************************

what is "an import or export specification"
how do i "create" one, and
how do i "save in the current database"?

thanks,
mac
0
Comment
Question by:MacRena
[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
  • 2
4 Comments
 
LVL 54

Accepted Solution

by:
nico5038 earned 50 total points
ID: 9659623
Just import a text file into access and the wizard will guide you through the process asking the separator character or fixed width, etc. During this session you'll have an "Advanced" button. When you press that you'll see the specification per field.
This can be saved and referred to in a docmd.transfertext acImport
Access will store these spec's in two normally "hidden" Msys tables.

Need more info ?

Nic;o)
0
 
LVL 4

Author Comment

by:MacRena
ID: 9660358
hello, Nico!!!!
how have you been?  thanks for another bit of education.  i haven't used the wizard in years and didn't remember that the specs. were there.
what have you been up to?
i'm still working as an Access programmer, but the customer has offered me a terrific salary to run her office in the beautiful mountains of Colorado.
i would miss full time programming, but i could still do it on my own time.
don't know which way to go.
thanks again.  and take care!
mac
0
 
LVL 54

Expert Comment

by:nico5038
ID: 9660840
Hi Mac,

Nice to hear from you !

I've been fine. Had to switch jobs this year and I'm still looking for something steady next year, but Access is really keeping me busy :-)
It's not easy in The Netherlands at the moment to get a job in automation, but that's a worldwide problem...

I have a nice book with areal photo's of Colorado, are you located somewhere in the region of Denver perhaps?

C U !

Nic;o)

0
 
LVL 4

Author Comment

by:MacRena
ID: 9661138

yep - a little town, absolutely beautiful, south west of Denver

http://maps.yahoo.com/maps_result?ed=M7tNO.p_0TqT&csz=evergreen+%2C+co&country=us

i will probably take the job after the new year, but i'm still in Pennsylvania at the moment.

best of luck finding work in your chosen profession - i'm not excited about the "Office Manager" job they offered, but they really want me, so they offered a good salary.

take care, Nico!
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

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
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
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 …

624 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