Hello,
Hoping someone can help me out.
When I select all records in a table, copy them to the clip board, and paste
them to Excel the names of the fields appear in the first row in Excel.
Such as FirstName, LastName, Phone, etc. I want to be able to paste only
the records, not the field names. I know I can delete the first row in
Excel to remove them, but that is not going to solve my problem. This also
occurs when I copy the records from a form or query. I have tried numerous
things, but have had no luck.
Does anyone know how to accomplish this? This problem is holding up my
project.
Thanks! 3 1879
In Excel, go to Data|Import External Data|Import Data...
Select the mdb file, work your way through the dialog boxes. On the last one where is asks
you which cell to start pasting in, there is an Options button. Uncheck the Field Names
box.
--
Wayne Morgan
"Frank K." <No**@aol.com> wrote in message
news:AP*******************@twister.tampabay.rr.com ... Hello,
Hoping someone can help me out.
When I select all records in a table, copy them to the clip board, and paste them to Excel the names of the fields appear in the first row in Excel. Such as FirstName, LastName, Phone, etc. I want to be able to paste only the records, not the field names. I know I can delete the first row in Excel to remove them, but that is not going to solve my problem. This also occurs when I copy the records from a form or query. I have tried numerous things, but have had no luck.
Does anyone know how to accomplish this? This problem is holding up my project.
Thanks!
Wayne - thanks for the response. However that is not what I want to do.
I was using Excel as an example - I am actually going to have the user paste
the records into an in house program that doesn't allow for that type of
manipulation. They can only paste what is on the clip board. What I really
need to know is if there is a way to eliminate the field names, or hide the
field names, when copying the records to the clip board.
Anyone have any ideas?
"Wayne Morgan" <co***************************@hotmail.com> wrote in message
news:UZ******************@newssvr32.news.prodigy.c om... In Excel, go to Data|Import External Data|Import Data...
Select the mdb file, work your way through the dialog boxes. On the last
one where is asks you which cell to start pasting in, there is an Options button. Uncheck
the Field Names box.
-- Wayne Morgan
"Frank K." <No**@aol.com> wrote in message news:AP*******************@twister.tampabay.rr.com ... Hello,
Hoping someone can help me out.
When I select all records in a table, copy them to the clip board, and
paste them to Excel the names of the fields appear in the first row in Excel. Such as FirstName, LastName, Phone, etc. I want to be able to paste
only the records, not the field names. I know I can delete the first row in Excel to remove them, but that is not going to solve my problem. This
also occurs when I copy the records from a form or query. I have tried
numerous things, but have had no luck.
Does anyone know how to accomplish this? This problem is holding up my project.
Thanks!
You can copy data to the clipboard programatically using the appropriate
win32 APIs. By that means, you can put watevr data you want on the
clipboard. But it might be a bit of a learning curve, if you have never used
win32 APIs from Access, before. Also, your users could no longer just select
records & press ctrl-C. They would have to click a button (or similar) to
start the relevant code.
HTH,
TC
"frank" <no**@aol.com> wrote in message
news:Ur*********************@twister.tampabay.rr.c om... Wayne - thanks for the response. However that is not what I want to do.
I was using Excel as an example - I am actually going to have the user
paste the records into an in house program that doesn't allow for that type of manipulation. They can only paste what is on the clip board. What I
really need to know is if there is a way to eliminate the field names, or hide
the field names, when copying the records to the clip board.
Anyone have any ideas?
"Wayne Morgan" <co***************************@hotmail.com> wrote in
message news:UZ******************@newssvr32.news.prodigy.c om... In Excel, go to Data|Import External Data|Import Data...
Select the mdb file, work your way through the dialog boxes. On the last one where is asks you which cell to start pasting in, there is an Options button. Uncheck the Field Names box.
-- Wayne Morgan
"Frank K." <No**@aol.com> wrote in message news:AP*******************@twister.tampabay.rr.com ... Hello,
Hoping someone can help me out.
When I select all records in a table, copy them to the clip board, and paste them to Excel the names of the fields appear in the first row in
Excel. Such as FirstName, LastName, Phone, etc. I want to be able to paste only the records, not the field names. I know I can delete the first row
in Excel to remove them, but that is not going to solve my problem. This also occurs when I copy the records from a form or query. I have tried numerous things, but have had no luck.
Does anyone know how to accomplish this? This problem is holding up
my project.
Thanks!
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Alex Hunsley |
last post by:
There's no really specific questions in this post, but I'm looking for
people's thought on the issues within...
The two main versions I've encountered for data pseudo-hiding
(encapsulation) in...
|
by: Jacky11 |
last post by:
Can anyone help me?
Please see the code I'm using now.
Public Function sheetlayout()
On Error GoTo Err_Command1_Click
Dim xl As Object
Set xl = GetObject("c:\windows\desktop\123.csv")...
|
by: Amber |
last post by:
The DataGrid allows you to make columns visible or invisible on demand
- even edit and other special columns. This article will show you how
it is done.
Some developers have reported problems...
|
by: Rob Meade |
last post by:
Hi all,
I've got myself into a bit of a problem and I'm trying to dig my way back
out, in a) the quickest way due to project deadline and also b) best
approach.
I have a form which gets a set...
|
by: Ste |
last post by:
Hi there,
I've got a website with a list of Frequently Asked Questions, so
there's a question and answer in a long list down the page.
Can anyone recommend a simple script that would allow me...
|
by: subramanian100in |
last post by:
Is my following understanding correct ?
Data abstraction means providing the interface - that is, the set of
functions that can be called by the user of a class.
Information hiding means...
|
by: developer.new |
last post by:
Hi
I have a question regarding this concept I learned about recently:
Name Hiding. Here's what I've come across:
There is a base class with two functions with the same name but
different...
|
by: Sh4wn |
last post by:
Hi,
first, python is one of my fav languages, and i'll definitely keep
developing with it. But, there's 1 one thing what I -really- miss:
data hiding. I know member vars are private when you...
|
by: Frinavale |
last post by:
This question may seem a bit newbie-ish but I'm new to desktop applications...please bear with me.
I have a function that populates a ComboBox with a bunch of names.
To populate it I have to make...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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...
|
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...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
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,...
|
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...
| |