[AccessD] Import Specs

You're right.  It's not obvious. To find the specs, do the following:
1.  Open the app mdb File, Get External Data, Import -> get file select
window
2.  Choose Files of Type: txt -> get file browse window
3.  Select any text format file, OK -> get Import Text Wizard window
4.  Select Advanced in lower left -> get window on format specs
5.  Select Specs on right side of window -> get list of specs in that mdb
6.  Select spec and get window to change its name or edit the field specs.

If you use DoCmd.TransferText with fixed format for import or export, you
need a correct spec.  Last I did it, if you want comma delimited format
either in or out, you need to name an existing spec although it's not used.
The field definitions don't matter.

If you make a new mdb by importing all the objects from an old one, there is
a non-obvious checkbox that says, as I recall: Include Import Specs.


  -----Original Message-----
  From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Mark Boyd
  Sent: Thursday, February 20, 2003 9:38 AM
  To: AccessD at databaseadvisors.com
  Subject: [AccessD] Import Specs


  Where does Access store import specs?

  I'm guessing there is a hidden system table that holds the layout for
these specs.

  If so, how do I get to them?



  Thanks,

  Mark Boyd

  Sr. Systems Analyst

  McBee Associates, Inc.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030220/df84c102/attachment-0002.html>