Exporting Access Tables to Comma-Delimited Text File

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

    Exporting Access Tables to Comma-Delimited Text File

    When I use the File -Export function in Access, all it seems to do
    is duplicate the file. It doesn't seem to offer conversion to
    delimited text files.

    Can someone tell me how to do that kind of an export? Or does Access
    call it something else?

    Thanks, Scott
    Tags: None
    • Pachydermitis
      #2
      Re: Exporting Access Tables to Comma-Delimited Text File

      On Jun 18, 10:19 am, Uncle Scotty <scottspieg...@ gmail.comwrote:
      When I use the File -Export function in Access, all it seems to do
      is duplicate the file. It doesn't seem to offer conversion to
      delimited text files.
      >
      Can someone tell me how to do that kind of an export? Or does Access
      call it something else?
      >
      Thanks, Scott
      In the export dialog box you should be able to see a 'save as type'
      select list. Choose the appropriate format in there. You can also
      choose export by right clicking on the table you want to export.
      hth

        Comment

        • paii, Ron
          #3
          Re: Exporting Access Tables to Comma-Delimited Text File


          "Uncle Scotty" <scottspiegler@ gmail.comwrote in message
          news:7a02566f-8f32-4113-846f-80efb1f53986@w7 g2000hsa.google groups.com...
          When I use the File -Export function in Access, all it seems to do
          is duplicate the file. It doesn't seem to offer conversion to
          delimited text files.
          >
          Can someone tell me how to do that kind of an export? Or does Access
          call it something else?
          >
          Thanks, Scott
          A97
          Select the table or query
          Select "Save as Export" from the File pull-down
          Send it to an External file or database
          Set Save as Type to Text
          Follow the prompts


            Comment

            • Uncle Scotty
              #4
              Re: Exporting Access Tables to Comma-Delimited Text File

              Do you have to be in a particular mode in Access to do this? I just
              opened up the app, opened the db of interest, and then I am presented
              with the various tables which comprise the db. Is it from that place
              that I can do what you are suggesting?

              On Jun 18, 1:31 pm, Pachydermitis <praesa...@gmai l.comwrote:
              On Jun 18, 10:19 am, Uncle Scotty <scottspieg...@ gmail.comwrote:
              >
              When I use the File -Export function in Access, all it seems to do
              is duplicate the file. It doesn't seem to offer conversion to
              delimited text files.
              >
              Can someone tell me how to do that kind of an export? Or does Access
              call it something else?
              >
              Thanks, Scott
              >
              In the export dialog box you should be able to see a 'save as type'
              select list. Choose the appropriate format in there. You can also
              choose export by right clicking on the table you want to export.
              hth

                Comment

                • KC-Mass
                  #5
                  Re: Exporting Access Tables to Comma-Delimited Text File

                  Yes

                  Highlight a table by clicking it. Go to the topmost menu Under "File" you
                  will find "Export". Click on it.
                  It will present you with a small panel with two bars in the bottom of the
                  window that let you establish the name to export it as and the second one
                  which defaults to Access but in which you can choose many formats. Click
                  the arrow head to see them. Scroll down to "Text" and select it. You will
                  get another panel that asks if you want it delimited, etc. Easy - But not
                  Obvious.

                  Regards

                  Kevin
                  "Uncle Scotty" <scottspiegler@ gmail.comwrote in message
                  news:2b3467b9-72d8-4c32-ab39-78dfc5e64bdc@x3 5g2000hsb.googl egroups.com...
                  Do you have to be in a particular mode in Access to do this? I just
                  opened up the app, opened the db of interest, and then I am presented
                  with the various tables which comprise the db. Is it from that place
                  that I can do what you are suggesting?
                  >
                  On Jun 18, 1:31 pm, Pachydermitis <praesa...@gmai l.comwrote:
                  >On Jun 18, 10:19 am, Uncle Scotty <scottspieg...@ gmail.comwrote:
                  >>
                  When I use the File -Export function in Access, all it seems to do
                  is duplicate the file. It doesn't seem to offer conversion to
                  delimited text files.
                  >>
                  Can someone tell me how to do that kind of an export? Or does Access
                  call it something else?
                  >>
                  Thanks, Scott
                  >>
                  >In the export dialog box you should be able to see a 'save as type'
                  >select list. Choose the appropriate format in there. You can also
                  >choose export by right clicking on the table you want to export.
                  >hth
                  >

                    Comment

                    Previous template Next
                    Working...