Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2005
    Posts
    28

    Unanswered: How to specify schema.ini in transfertext Macro Command

    Hi Forum,

    I have few text files that are '~' delimited. I would like to create a macro that can use schema.ini that will have the details of all of my text files. These text files do not have a header record.

    Please help me in creating a Macro.

    Thanx a ton in advance...

    Sunil

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    I am not sure what you mean by Schema.ini, but in Access you can create a File Specification for each file. The File Specification allows you to choose whether the file is fixed field or delimited. In your case you can select the delimiter and give the fields names.

    To do this I would start with File/Get External Data/Link Tables then choose a file. Then when the Wizard comes up click on the Advanced button. This will allow you the most flexibility and to name the File Specification. From there, create the macro using the File Specification you made when linking to the file.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •