473,387 Members | 1,574 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,387 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 5101
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...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
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...

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.