Transfer database

[Tom Tripicchio]

I am running a query and would like to export the spreadsheet in a .csv
file.
My only choices for spreadsheet type are excel and lotus. Is there a way to
add other types of files?

Thanks, Tom

 

[Joseph Meehan]

I am running a query and would like to export the spreadsheet in a .csv
file.
My only choices for spreadsheet type are excel and lotus. Is there a way
to
add other types of files?

Thanks, Tom

From my help file:

In the Database window, click the name of the table, query, view, or stored
procedure you want to export, and then on the File menu, click Export.

In the Save as type box, click Text Files (*.txt; *.csv; *.tab; *asc).

Click the arrow to the right of the Save in box, and select the drive or
folder to export to.

In the File Name box, enter a name for the file (or use the suggested name),
and then click Export.

Microsoft Access starts the Export Text Wizard.

Follow the directions in the dialog boxes. Click Advanced to create or use
an import/export specification.

 

[Tom Tripicchio]

I saw this on the Microsoft web page but I have 2 problems. I do not have
..csv file as a selection. And the second is I would like to automate the
process by using a macro to generate the file and then use the transfer
database selection with the CSV format. So I do not have to perform all of
the steps that you mentioned. I can do this with excel and lotus, so if I
can do the same with the csv file that would be great.