Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2650
  • Last Modified:

DoCmd.TransferText - What is "SpecificationName"?

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
MacRena
Asked:
MacRena
  • 2
  • 2
1 Solution
 
nico5038Commented:
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
 
MacRenaAuthor Commented:
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
 
nico5038Commented:
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
 
MacRenaAuthor Commented:

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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now