How to create own tab delimited file

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Danny
    #1

    How to create own tab delimited file

    How do you create your own tab delimited ms access file.
    What is the TAB character and what is the NEWLINE character,
    also how to write to a text file

    Thanks in advance


    Tags: None
    • Lyle Fairfield
      #2
      Re: How to create own tab delimited file

      "Danny" <dannywork5@hot mail.com> wrote in news:32JWb.8522 $I67.3108570
      @news4.srv.hcvl ny.cv.net:
      [color=blue]
      > How do you create your own tab delimited ms access file.
      > What is the TAB character and what is the NEWLINE character,
      > also how to write to a text file[/color]

      Perhaps, learning to use the help file wuld be a great plane for you.

      Assuming a current version of access, open the VB Window with <ALT><F


      --
      Lyle
      (for e-mail refer to http://ffdba.com/contacts.htm)

        Comment

        • Lyle Fairfield
          #3
          Re: How to create own tab delimited file

          "Danny" <dannywork5@hot mail.com> wrote in news:32JWb.8522 $I67.3108570
          @news4.srv.hcvl ny.cv.net:
          [color=blue]
          > How do you create your own tab delimited ms access file.
          > What is the TAB character and what is the NEWLINE character,
          > also how to write to a text file
          >
          > Thanks in advance[/color]

          Assuming a not too ancient version of Access open the VB window with <ALT>
          <F11>. Click Help.
          Type something like
          "how to write to a file"
          into the Answer Wizard dialog.
          You will find references to all you need to know, and you can pick what is
          suitable for you.

          Of course, if you are exporting data, you may want to look at the
          "TransferTe xt" method, which does most of the dirty work for you.

          I recommend using VBNewline and VBTab for new line and tab characters.

          --
          Lyle
          (for e-mail refer to http://ffdba.com/contacts.htm)

            Comment

            • Lyle Fairfield
              #4
              Re: How to create own tab delimited file

              Lyle Fairfield <MissingAddress @Invalid.Com> wrote in
              news:Xns948D3E6 F11E22FFDBA@130 .133.1.17:
              [color=blue]
              > "Danny" <dannywork5@hot mail.com> wrote in news:32JWb.8522 $I67.3108570
              > @news4.srv.hcvl ny.cv.net:
              >[color=green]
              >> How do you create your own tab delimited ms access file.
              >> What is the TAB character and what is the NEWLINE character,
              >> also how to write to a text file[/color]
              >
              > Perhaps, learning to use the help file wuld be a great plane for you.
              >
              > Assuming a current version of access, open the VB Window with <ALT><F[/color]

              Hmmm ... perhaps one should be careful with the <ALT> and Function keys when
              writing a reply with XNews as it seems there is some combination that posts
              the message and closes the window without warning.

              --
              Lyle
              (for e-mail refer to http://ffdba.com/contacts.htm)

                Comment

                • Danny
                  #5
                  Re: How to create own tab delimited file

                  THank you

                  I have to put some header info into this file, so I cant just export, but do
                  you know if there is an easy way to combine two text files in access? This
                  way I can do the export, and just append this file to the header text file.

                  Thanks in advance

                  "Lyle Fairfield" <MissingAddress @Invalid.Com> wrote in message
                  news:Xns948D3F6 5841E4FFDBA@130 .133.1.17...[color=blue]
                  > "Danny" <dannywork5@hot mail.com> wrote in news:32JWb.8522 $I67.3108570
                  > @news4.srv.hcvl ny.cv.net:
                  >[color=green]
                  > > How do you create your own tab delimited ms access file.
                  > > What is the TAB character and what is the NEWLINE character,
                  > > also how to write to a text file
                  > >
                  > > Thanks in advance[/color]
                  >
                  > Assuming a not too ancient version of Access open the VB window with <ALT>
                  > <F11>. Click Help.
                  > Type something like
                  > "how to write to a file"
                  > into the Answer Wizard dialog.
                  > You will find references to all you need to know, and you can pick what is
                  > suitable for you.
                  >
                  > Of course, if you are exporting data, you may want to look at the
                  > "TransferTe xt" method, which does most of the dirty work for you.
                  >
                  > I recommend using VBNewline and VBTab for new line and tab characters.
                  >
                  > --
                  > Lyle
                  > (for e-mail refer to http://ffdba.com/contacts.htm)[/color]


                    Comment

                    • Bas Cost Budde
                      #6
                      Re: How to create own tab delimited file

                      Danny wrote:
                      [color=blue]
                      > THank you
                      >
                      > I have to put some header info into this file, so I cant just export, but do
                      > you know if there is an easy way to combine two text files in access? This
                      > way I can do the export, and just append this file to the header text file.[/color]

                      You could create a batch file that does copy file1.txt+file2 .txt
                      result.txt and call that from Shell()
                      --
                      Bas Cost Budde
                      http://www.heuveltop.org/BasCB

                      but the domain is nl

                        Comment

                        Previous template Next
                        Working...