copying text out of datasheet

[Arjay418]

Hi All,

Is there a way to copy text out of a datasheet where it can be pasted into another application as simple text?

Maybe think of it this way: in Excel, you can copy a series of cells, then Paste Special and choose Values. essentially, this action strips away any of the fancy formatting or formulas, etc and just pastes the simple value. Another way to think about it is that you can copy a series of cells in an Access datasheet and then paste them into a .txt file. They will appear without special formatting, without any sort of "cell designation"---almost as if you had typed them in yourself (and hit enter after each one).

Presumably, this action of stripping away the fancy stuff happens when you paste. I am trying to paste these values into an application that doesn't have the ability to Paste Special > Values, or to strip away any of that fancy stuff. As such, it doesn't recognize Paste action at all.

Is there a way to COPY the information out of the Access datasheet in a basic format so that my other (dumber) application will recognize it? If not, I will be study copying out of Access into Notebook and out of Notebook into my application.

Any ideas?

Thanks.

--RJ

 

[Remou]

You could loop through your recordset and write to a file using either the OpenTextFile method of the FileSystemObject or the Open Statement, either of which can be used to write a file.