473,432 Members | 1,736 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,432 software developers and data experts.

Not able to paste full string from database into excel

anoble1
245 128KB
When I am copying and pasting into excel from MS Access I am only getting a portion on what is in the table. I think it has to do with the large space/spaces is why it won't paste. When I do
Expand|Select|Wrap|Line Numbers
  1. Replace([Field],Chr(9),"")
or
Expand|Select|Wrap|Line Numbers
  1. Replace([Field],"  ","")
it does nothing. Here is what I get when I paste in excel. This is about 41 words. The whole string is 101 words.
"I gave the Persons the road numnber and street number to Andys office.

A.Prite09.09.2022:
As a normal course of business, company seeing the effectiveness of all our businesses, locations, everything etc. so we can use our findings as efficiently as po"
Dec 5 '22 #1
1 5104
NeoPa
32,556 Expert Mod 16PB
Have you tried pasting the value into somewhere else first? That might allow you to determine if it's the Copy or the Paste that is causing the issue.

I can't say I'm familiar with such a small limit. I've seen where a 1,024 limit gets hit, but even then it's only with multiple items being transferred.

I'm assuming that isn't the case here or you would obviously have included that in the question.
Dec 6 '22 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: leRomeo | last post by:
I want to write an C# App to paste a string into the webform textbox whenever a button of the App clicked. Source string can be from cache or from a windows textbox or wherever else. Anyone knows...
2
by: TM | last post by:
I have an Excel sheet where I setup my needed formatting, page settings, ect, and would like to take my data from a datagrid and paste it into the excel file and print the excel file. Any idea...
0
by: vinidimple | last post by:
Hi i have a serious problem while i was working in Excel.I want to fetch columns from an excel worksheet and i need to compare it with an sql querry fields,so i tried to open an excle...
0
by: 29kat | last post by:
I need to find one specific string which is available in the excel sheet from Visual Basic and I want to get the details or values related to that specified string in excel from VB.
1
by: xinelo | last post by:
HI, In Perl I use quite a lot the caret inside the brackets to match everything up to a certain character, for example, all characters which are not an opening xml tag (<) up to the next xml tag:...
1
by: mmr315 | last post by:
Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\databaseconnect.php on line 5 i wrote code like this ...
2
by: COHENMARVIN | last post by:
I have a listbox of cities. The listbox is bound to a database table. But I want to add the option - "all cities" to the listbox. How do I do that? Thanks, Marvin
0
by: phpuser123 | last post by:
I want to display my string str as the defaultinput value and when I run ,oly the first part of the word is displayed. It skips everything after the blank space.How do I sort this out? <% ...
5
by: andy1989 | last post by:
I am trying to find a string in excel sheet and store the string cell address in an array. This string appears several times. By storing every cell address where the string is located, im checking if...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.