Is there anyway to copy a row off of MS Access without getting the

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Anyone who's copied a row from MS access and then pasted it into excel knows
that it actually copies the headers as well as the rows.
So you have to remove the headers.

Is there anyway to copy a row off of MS Access without getting the headers
too?

So you could cleanly just copy from access and paste to excel.
 
No, not if you're using Copy (Ctrl+c) and Paste (Ctrl+v).
 
The only way I know how to do it is to paste into Notepad (or another text
editor) first, then recopy only the data abd paste into Excel. If you are
going to do 2 steps, you might as well just paste into Excel and delete the
header row.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Thanks,
I'll guess I'll just write a small VBA Excel Macro "Paste Access Table W/O
Headers" and create a shortcut for it or an icon.

Roy.
 
I created a small macro that does it, so instead of CTRL-V i use another
combination like CTRL-W

ActiveSheet.Paste
Range(ActiveCell.Address).Select
Selection.EntireRow.Delete
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Help to copy information from one row at a time to another sheet 1
Transferspreadsheet - insert rows with no header 1
Copy Excel Data to Access 1
INSERT to excel file 4
Can you copy query results from Access to Excel without headers? 1
Exporting into Excel / Text getting 'chopped off' 3
copy data from one datatable to another - different schemas 2

Back
Top