Exporting Access Tables to Comma-Delimited Text File

[Uncle Scotty]

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

[Pachydermitis]

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

[paii, Ron]

"Uncle Scotty" <sc***********@ gmail.comwrote in message
news:7a******** *************** ***********@w7g 2000hsa.googleg roups.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

[Uncle Scotty]

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

[KC-Mass]

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" <sc***********@ gmail.comwrote in message
news:2b******** *************** ***********@x35 g2000hsb.google groups.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