Copying Data from report to excel

[MattG]

At our company we have various types of excel files we fill out in tracking inventory. I made a report that tells me how much stuff I have and the details of that stuff. It takes the information from the record associated with it.

I am finding it useful to take the database portion of some of these reports and copy the data into excel. The odd thing is that it adds a row between every record. Anyone ever have this issue or have a solution to keep it from doing this?

Matt

[Pat Stanford]

I am not seeing that here.

I created a worksheet and database. Copied and pasted just the database row data into Excel 2008. No blank rows

Selected and pasted the entire database rows (clicking in the row headers). No blank rows.

Selected and pasted the entire worksheet from edit mode. No blank lines

Copied and pasted the worksheet image from the drawing. Pasted into Excel as a picture.

Have you tried exporting the file to a CSV or tab delimited text file and reading that in to Excel. Then copy and paste from that Excel file into your real excel files?

Or send me a copy of the VW file and I will try it here.

[MattG]

I wonder if it is a vw2008 thing or an excel 2003 thing.

I am putting up some screen shots to show what I am talking about, but I keep getting it.

Matt

[Pat Stanford]

Have you tried some of the Paste Special options?

[MattG]

Gave that a try no luck either. A little strange to me.

Matt

[Hugues]

Hi Matt,

This was a bug in VW2008. It is fixed in VW2009.

Best Regards,

Hugues

NNA