Exporting Text with a data to a delimited text file

[Guest]

I'm exporting a query to a delimited text file. The query has a date field
which is formatting a field to (Format([sTime],'mm/dd/yyy').

My problem is that when I run the macro to export the data, the date field
is exported in quotes "06/29/2005".

The exported file is being imported into another application which will not
accept the quotes. Can anyone tell me how to export this without the quotes
on the date field?

 

[Ken Snell [MVP]]

You also need to use an export specification for the export. The
specification will tell ACCESS not to treat the result as a string, but
instead as a date.

You can set up an export specification by doing the export manually -- and
then, on the last screen of the wizard window, click the Advanced button at
bottom left of the screen. A screen will display that allows you to set the
data type, etc. of the individual fields. You then can save that
specification with any name you wish. You then can cancel the export that
you'd begun.

Then use this export specification name as the "Specification" argument of
the TransferText action.

 

[Guest]

Thanks Ken! That did the trick!

You also need to use an export specification for the export. The
specification will tell ACCESS not to treat the result as a string, but
instead as a date.

You can set up an export specification by doing the export manually -- and
then, on the last screen of the wizard window, click the Advanced button at
bottom left of the screen. A screen will display that allows you to set the
data type, etc. of the individual fields. You then can save that
specification with any name you wish. You then can cancel the export that
you'd begun.

Then use this export specification name as the "Specification" argument of
the TransferText action.

--

Ken Snell
<MS ACCESS MVP>

I'm exporting a query to a delimited text file. The query has a date
field
which is formatting a field to (Format([sTime],'mm/dd/yyy').

My problem is that when I run the macro to export the data, the date field
is exported in quotes "06/29/2005".

The exported file is being imported into another application which will
not
accept the quotes. Can anyone tell me how to export this without the
quotes
on the date field?

 

[Guest]

I am having the same issue but the only way i know how to export something to
a text document is by using the export option that appears when you right
click on the table/query, so i'm not getting to any wizard. also is it
possible to not only remove the quotations (i'm exporting a list of emails
that need to be seperated only by a semicolin to a text file) but to
eliminate the newline char and add the ';'?
thanks,
Maurie

Thanks Ken! That did the trick!

You also need to use an export specification for the export. The
specification will tell ACCESS not to treat the result as a string, but
instead as a date.

You can set up an export specification by doing the export manually -- and
then, on the last screen of the wizard window, click the Advanced button at
bottom left of the screen. A screen will display that allows you to set the
data type, etc. of the individual fields. You then can save that
specification with any name you wish. You then can cancel the export that
you'd begun.

Then use this export specification name as the "Specification" argument of
the TransferText action.

--

Ken Snell
<MS ACCESS MVP>

I'm exporting a query to a delimited text file. The query has a date
field
which is formatting a field to (Format([sTime],'mm/dd/yyy').

My problem is that when I run the macro to export the data, the date field
is exported in quotes "06/29/2005".

The exported file is being imported into another application which will
not
accept the quotes. Can anyone tell me how to export this without the
quotes
on the date field?

 

[Ken Snell \(MVP\)]

See File | Export option on the menubar.

--

Ken Snell
<MS ACCESS MVP>

I am having the same issue but the only way i know how to export something
to
a text document is by using the export option that appears when you right
click on the table/query, so i'm not getting to any wizard. also is it
possible to not only remove the quotations (i'm exporting a list of emails
that need to be seperated only by a semicolin to a text file) but to
eliminate the newline char and add the ';'?
thanks,
Maurie

Thanks Ken! That did the trick!

You also need to use an export specification for the export. The
specification will tell ACCESS not to treat the result as a string, but
instead as a date.

You can set up an export specification by doing the export manually --
and
then, on the last screen of the wizard window, click the Advanced
button at
bottom left of the screen. A screen will display that allows you to set
the
data type, etc. of the individual fields. You then can save that
specification with any name you wish. You then can cancel the export
that
you'd begun.

Then use this export specification name as the "Specification" argument
of
the TransferText action.

--

Ken Snell
<MS ACCESS MVP>

I'm exporting a query to a delimited text file. The query has a date
field
which is formatting a field to (Format([sTime],'mm/dd/yyy').

My problem is that when I run the macro to export the data, the date
field
is exported in quotes "06/29/2005".

The exported file is being imported into another application which
will
not
accept the quotes. Can anyone tell me how to export this without the
quotes
on the date field?