Output report into tab delimited, CSV format

[Guest]

I want to output a report in tab delimited format. If I create an export specification, it decides where the tabs are, and that is not where I need them to be.

I guess what I am asking is how do I show, in the report, where the tabs should go?

Thanks in advance!

 

[Gary Miller]

Amanda,

All data in Access and in most databases, is just stored in
a very raw format. Whether you export data as tab delimited
or comma delimited or whatever, it is still just seperators
of the pieces and has nothing to do with spacing.

If you are counting on the data to provide your spacing on a
report, that is the reverse of how it works. The data is
data. You need to work with the controls on the report for
formatting, by presetting them or dealing with them
conditionally with VBA Code. If you are exporting raw data
( as it sounds ) it is up to the folks on the other end to
format it as needed. Formatting is a presentation feature
only. Data storage is formatting independent. This gives you
a lot of flexibility on who you show it when.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
message

I want to output a report in tab delimited format. If I

create an export specification, it decides where the tabs
are, and that is not where I need them to be.

 

[Guest]

Thank you.
What I need to do is export an access report that can be imported into QuickBooks. QB is very tempermental, and requires a very specific tab delimited format. I don't want to have to open the data in another application to manipulate it, but to export the exact format from access.
I have designed the report to completely match QB's import requirements, but when QB attempts to read it, it can't separate the items, it either runs together or it thinks each space is a separator.

I understand now that the export data is simply data, but is there any way to write a tab character between items?