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?

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

--
Duane Hookom
MS Access MVP


"Mrinal Das" <Mrinal (E-Mail Removed)> wrote in message
news:CEC39597-6A2F-4852-9CF3-(E-Mail Removed)...
> 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?
>

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.

"Duane Hookom" wrote:

> You can right-click your crosstab and choose to export. Select the proper
> file type and set the delimiter to tab.
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "Mrinal Das" <Mrinal (E-Mail Removed)> wrote in message
> news:CEC39597-6A2F-4852-9CF3-(E-Mail Removed)...
> > 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?
> >
>
>
>

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

--
Duane Hookom
MS Access MVP


"Mrinal Das" <(E-Mail Removed)> wrote in message
news:5726AAE2-77CD-4ADE-95BE-(E-Mail Removed)...
> 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.
>
> "Duane Hookom" wrote:
>
>> You can right-click your crosstab and choose to export. Select the proper
>> file type and set the delimiter to tab.
>>
>> --
>> Duane Hookom
>> MS Access MVP
>>
>>
>> "Mrinal Das" <Mrinal (E-Mail Removed)> wrote in message
>> news:CEC39597-6A2F-4852-9CF3-(E-Mail Removed)...
>> > 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?
>> >
>>
>>
>>