Solved

DoCmd.TransferText - What is "SpecificationName"?

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Top 1 of each supplier 55 57
Modal form 11 30
trying to catch ODBC error when database opens 2 28
update all email addresses SQL 1 24
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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…

809 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