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

G

Guest

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?
 
D

Duane Hookom

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

exporting a report in text - comma delimited format 1
Unable to export report to text 1
Access Access Export Delimited Problem 0
Export to Tab delimited text file 4
Export from MS Access 2007 to Quickbooks IIF - How can I create a tabdelimited text file from Access 2
Export to RTF/HTML corrupts report 3
Exporting Table to Text file including Fielnames 2
Output report into tab delimited, CSV format 2

Top