Solved

DoCmd.TransferText - What is "SpecificationName"?

Posted on 2003-10-31
4
2,595 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

739 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