LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35
Default Paste from Access

Excel and Access 2002 SP3

User copies a street address from a form in 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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
COPY DATA FROM ACCESS - PASTE IN EXCEL CHRISTI Excel Worksheet Functions 0 January 25th 08 08:03 AM
Can't Access Paste Special Anymore Joe VW Excel Worksheet Functions 5 November 4th 06 03:06 PM
Access Form In An Access Report (SubForm) Question Gary Links and Linking in Excel 0 January 27th 06 05:54 AM
can't sum up items i cut&paste from access to excel.. caroline Excel Discussion (Misc queries) 1 December 17th 05 12:04 AM
Paste Access data into Excel spreadsheet JDM Excel Discussion (Misc queries) 1 April 29th 05 05:42 PM


All times are GMT +1. The time now is 05:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"