Access - Exporting to text

[StevenB]

OK, I've once again set Access aside for long enough that I totally have forgotten how to use it. Now it's aggravating me again, so I come to you begging for help, as usual.

I have an Access database (2000 format, but it could just as easily be 2003). Let's say, for the sake of simplicity, that I have two fields, an ID field and a Description field.

I created a report in Access that prints out a list like this:

ID = 123
Here is the description. Here is the description. Here is the description. Here is the description. Here is the description. Here is the description. Here is the description.

ID = 124
Here is the description. Here is the description. Here is the description. Here is the description. Here is the description. Here is the description. Here is the description.

I want to be able to export these results to a text file, so that I can easily cut-and-paste them into a thread on a message board.

However, when I export this to text, Access imposes all kinds of line breaks and stuff into the text, so I end up with something like this:

ID = 123
Here is the description. Here is the description. Here i
s the description. Here is the description. Here is the
description. Here is the description. Here is the descri
ption.

ID = 124
Here is the description. Here is the description. Here i
s the description. Here is the description. Here is the
description. Here is the description. Here is the descri
ption.

I'm really struggling to figure out how I can accomplish what I need. It LOOKS like it should be easy, but so far, no go. Thoughts?

 

[lameid]

You could Export the query itself to a text file. Although, it would have the ID on the same line as the description.

If you just wanted to copy and paste, you could use a form instead of the exported report.

Finally, you could write a program to manually dump the data in the layout you want, I wouldn't want to.

 

[StevenB]

Hmm, form probably won't work. Some of the categories I'm working with have hundreds of options, and if I understand you correctly, I'd have to cut-and-paste each option from a form.

Not going to write a program.

I'm testing out the query export right now, it looks like a possibility, at any rate.