Export part of table to .csv file

[Guest]

I know that it is possible to export an entire table to a csv file, but is it
possible to export only part of the table? (i.e. Have a prompt for a date and
then only export that date?)

I am using Access 2002 but with 2000 file formatting.

Thank you.

 

[pietlinden]

I know that it is possible to export an entire table to a csv file, but is it
possible to export only part of the table? (i.e. Have a prompt for a date and
then only export that date?)

I am using Access 2002 but with 2000 file formatting.

Thank you.

This is a joke, right?

How do you get part of a table? Use a query! Then just substitute
the query name for the table name in the DoCmd.TransferText stuff..
just specify object type=Query, and the query name...
Prompt for a date... so make the query an parameter query....

SELECT...
FROM...
WHERE SomeDate=[Please Enter a Date:];