Avoid Pasting Field names in Excel

[Drevlin]

When copying information from Access and pasting into Excel does anyone know how to NOT paste the Field names with the information? It's very annoying to have to paste the information next to my excel list and then have to copy and paste the cells into position without the field names.

Thanks in advance.

 

[k209310]

I`m not to sure how to pervent the pasting of field names by simply copying a table and pasting it in to excel.

If you use 'Database Queries' from the 'Get External Data' meun to automate the data transfer process then there is an option within properties to prevent a field name from being pasted.

This method will also save you the bother of having to copy and paste as the data in exel will automatically update itself.

 

[Drevlin]

I don't really think there's a way to do it. But I can't figure out Why Microsoft wouldn't want to give you the ability to turn this off...

What I am doing is an extremely randomized copy and paste job that can't be easily automated without losing the data's integrity. But I appreciate your suggestion.

Anyone else have any ideas?

Peace

 

[yellow]

Microsoft states that this behaviour is by design, which means it's pants!

See this:http://support.microsoft.com/default.aspx?scid=kb;en-us;Q168219

 

[Drevlin]

See... they SAY it's by design. But they don't explain why...

"Oh My God! They Killed Kenny!"

(insert next quote here to refer to Microsoft)