"KHOLM", Dude!!! Where's your 5-stars!!!

You ROCK!!! (can you sense the enthusiasm?)

You were right on, my man! Thanks! Can you enumerate the rest of the AcTextTransferType's or post a link to where we can get more info?

Here is an excerpt from Microsoft:

**** TransferText Method ****

The TransferText method carries out the TransferText action in Visual Basic.

expression.TransferText(TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName, CodePage)
  • expression - Required. An expression that returns one of the objects in the Applies To list.
  • TransferType - Optional AcTextTransferType.

    AcTextTransferType can be one of these constants:
    • acExportDelim
    • acExportDelim
    • acExportFixed
    • acExportHTML
    • acExportMerge
    • acImportDelim default
    • acImportFixed
    • acImportHTML
    • acLinkDelim
    • acLinkFixed
    • acLinkHTML
    If you leave this argument blank, the default constant (acImportDelim) is assumed.
  • SpecificationName - Optional Variant. A string expression that's the name of an import or export specification you've created and saved in the current database.
  • TableName - Optional Variant. A string expression that's the name of the Microsoft Access table you want to import text data to, export text data from, or link text data to, or the Microsoft Access query whose results you want to export to a text file.
  • FileName - Optional Variant. A string expression that's the full name, including the path, of the text file you want to import from, export to, or link to.
  • HasFieldNames - Optional Variant. Use True (1) to use the first row of the text file as field names when importing, exporting, or linking. Use False (0) to treat the first row of the text file as normal data. The default is (False).
  • HTMLTableName - Optional Variant. A string expression that's the name of the table or list in the HTML file that you want to import or link.
  • CodePage - Optional Variant. A Long value indicating the character set of the code page.
  • *** Remarks *** - You can leave an optional argument blank in the middle of the syntax, but you must include the argument's comma. If you leave a trailing argument blank, don't use a comma following the last argument you specify.
  • *** Note *** - You can also use ActiveX Data Objects (ADO) to create a link by using ActiveConnection property for the Recordset object.

    [ 14 May 2002, 00:21: Message edited by: 3MGrant5 ]