>I have a Text File (Data.lst) which is delimited by an exclamation mark (the
>wonders of AS400 will never cease to amaze me!)

>I am trying to transfer/import the file data, into ACC97.  My best guess has
>been:

> DoCmd.TransferText acImportDelim, "Import", "Data", "Data.lst", False

>...Where "Import" is a Macro Name which call this Function.
>...Where "Data" is the name of the Table which has predefined Fields,
>reflecting the text files !-delimited Fields.

>ACC97 does not appear to want to import the file, using ! as a delimiting
>character.  Does anyone know if I need to set this up somewhere?

> >This is probably simple ( very much like myself!):

> >I have a Text File (Data.lst) which is delimited by an exclamation mark
(the
> >wonders of AS400 will never cease to amaze me!)

> >I am trying to transfer/import the file data, into ACC97.  My best guess
has
> >been:

> > DoCmd.TransferText acImportDelim, "Import", "Data", "Data.lst", False

> >...Where "Import" is a Macro Name which call this Function.
> >...Where "Data" is the name of the Table which has predefined Fields,
> >reflecting the text files !-delimited Fields.

> >ACC97 does not appear to want to import the file, using ! as a delimiting
> >character.  Does anyone know if I need to set this up somewhere?

> You have to specify the delimiter in the import
> specification.  You say that IMPORT is a Macro Name, but it
> should be a Specification Name.

> You can create a specification by using the File - Get
> External Data - Import menu item and working your through
> the import wizard's dialog (use the Advanced option to set
> the delimiter) and saving all the details in a
> specification.

> --
> Marsh
> MVP [MS Access]