How do I export Access report to tab delimited Text file?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mrinal Das - 26 Oct 2005 15:22 GMT

I'm trying to export complex crosstab reports designed in Access 2003 to tab
delimited text file, so that the resulting text file can be used later to
import in Excel for manipulation. By using Access report Export facility I
could only export report to space delimited Text file, which doesn't solve my
problem. How do I export report to Tab delimited format?

Reply to this Message

Duane Hookom - 26 Oct 2005 15:53 GMT

You can right-click your crosstab and choose to export. Select the proper
file type and set the delimiter to tab.

Signature

Duane Hookom
MS Access MVP

> I'm trying to export complex crosstab reports designed in Access 2003 to
> tab
[quoted text clipped - 3 lines]
> my
> problem. How do I export report to Tab delimited format?

Reply to this Message

Mrinal Das - 26 Oct 2005 16:11 GMT

Thanks for your reply. But delimiter setting option doesn't appear during
report export. That is the exact problem I'm facing. The delimiter setting
option does appear in case of exporting Table/Query data to text format, but
it doesn't for report export.

> You can right-click your crosstab and choose to export. Select the proper
> file type and set the delimiter to tab.
[quoted text clipped - 6 lines]
> > my
> > problem. How do I export report to Tab delimited format?

Reply to this Message

Duane Hookom - 26 Oct 2005 16:15 GMT

Don't export the report. Export the query the report is based on.

Signature

Duane Hookom
MS Access MVP

> Thanks for your reply. But delimiter setting option doesn't appear during
> report export. That is the exact problem I'm facing. The delimiter setting
[quoted text clipped - 16 lines]
>> > my
>> > problem. How do I export report to Tab delimited format?

Reply to this Message