Paste Access into Excel

[Brenda from Michigan]

Excel and Access 2002 SP3

I asked this several days ago in the Excel forum but so far no response.

User copies a street address from Access; she wants to paste it
into an Excel document. Previously created documents paste the entire
street address into a single cell. Now the address is pasted with each word
put into a separate cell.

We tried Paste Special and get the option to paste as Unicode Text or Text,
but either one still pastes each word in a separate cell. We copied her
document to a new spreadsheet (corrupt Excel document?) and got the same
results. We created a new, blank Excel document and pasted into it with the
same results.

The user opens an existing document and pastes it, and the text pastes
perfectly into a single cell as you would expect. She does not know what may
have changed from the old document to newly created documents.

Our only workaround so far is to paste into Word, then copy/paste from Word
to Excel and it works. Can anyone offer any insight into what has changed
here because we're stumped. Thanks in advance!

 

[Douglas J. Steele]

I suspect the difference is that the user used the Text to Column options on
the Data menu, and the saved settings are conflicting with the data.

To fix the problem, I believe you'll have to go into Text To Column and
change the options. (It should be possible to do this from Access using
Automation)

 

[Brenda from Michigan]

Thanks. That seems to have worked for her.

I suspect the difference is that the user used the Text to Column options on
the Data menu, and the saved settings are conflicting with the data.

To fix the problem, I believe you'll have to go into Text To Column and
change the options. (It should be possible to do this from Access using
Automation)