Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

DoCmd.TransferText - What is "SpecificationName"?

Posted on 2003-10-31
4
Medium Priority
?
2,634 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 200 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

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.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
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.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

721 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