Table Export help needed

[knitter via AccessMonster.com]

I've never posted but have been reading and learning from here for a couple
of years. I hope someone can help now. Tried searching but haven't really
seen an answer for what I need.

I've inherited a database. For reasons I won't bore you with (too many, too
large, no time, etc), there are multiple tables with the same structure and
that can't change.

I need to build something that I can use to export each table into a text
file as needed. Is there a way to build a query that will allow me to chose
which table to export?

Thanks in advance for any help anyone can give!

 

[Steve]

You can use the Transfertext method to export a table to a text file. From
the Help file:

Syntax

DoCmd.TransferText [transfertype][, specificationname], tablename,
filename[, hasfieldnames][, HTMLtablename]

The tablename is a string expression. You could use a listbox or combobox
that lists all your tables and where the bound column is the name of the
table you select. This would give you a way to chose which table to export.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[knitter via AccessMonster.com]

Thanks Steve, I'll give that a try.

You can use the Transfertext method to export a table to a text file. From
the Help file:

Syntax

DoCmd.TransferText [transfertype][, specificationname], tablename,
filename[, hasfieldnames][, HTMLtablename]

The tablename is a string expression. You could use a listbox or combobox
that lists all your tables and where the bound column is the name of the
table you select. This would give you a way to chose which table to export.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

I've never posted but have been reading and learning from here for a
couple

[quoted text clipped - 13 lines]

Thanks in advance for any help anyone can give!