| separated csv output

[Henry]

is there a way to output table data | separated ?

I tried:
DoCmd.TransferText acExportDelim, ..............
CurrentDb.Execute "select * into [Text;FMT=Delimited;HDR=Yes;Database=C:\.....

but both output ; separated data.

henry

 

[Klatuu]

I would recommend the TransferText method
But, you will need to create an Import/Export spec to specify the separator
and other rules. To do this, do the transfer once manually. When you get to
the Export wizard, click on Advanced. You will be able to configure the
output at this point. Once you have it like you want it, click Save As and
give the spec a name. Then you can use that name in your TransferText method.

 

[Henry]

sorry I cant even find the Export wizard |-|

where is that hided ?

I would recommend the TransferText method
But, you will need to create an Import/Export spec to specify the separator
and other rules. To do this, do the transfer once manually. When you get to
the Export wizard, click on Advanced. You will be able to configure the
output at this point. Once you have it like you want it, click Save As and
give the spec a name. Then you can use that name in your TransferText method.

is there a way to output table data | separated ?

I tried:
DoCmd.TransferText acExportDelim, ..............
CurrentDb.Execute "select * into [Text;FMT=Delimited;HDR=Yes;Database=C:\.....

but both output ; separated data.

henry

 

[Klatuu]

First, in the database window, place the cursor on the table you want to
export.
From the main menu:
File, Export

Now you have the common open/save dialog. Identify the path and filename.
Use .csv as the file extension. (Select "Text File")

Click Export

Now you have the wizard in front of you. Here is where you click on Advanced.

sorry I cant even find the Export wizard |-|

where is that hided ?

I would recommend the TransferText method
But, you will need to create an Import/Export spec to specify the separator
and other rules. To do this, do the transfer once manually. When you get to
the Export wizard, click on Advanced. You will be able to configure the
output at this point. Once you have it like you want it, click Save As and
give the spec a name. Then you can use that name in your TransferText method.

is there a way to output table data | separated ?

I tried:
DoCmd.TransferText acExportDelim, ..............
CurrentDb.Execute "select * into [Text;FMT=Delimited;HDR=Yes;Database=C:\.....

but both output ; separated data.

henry