Paste Special, Values, Transpose

Is there a way in Access 2007 to use the paste special features available in
Excel?  I have data in Excel that I will be copying and pasting into a form
in Access.  Importing would be tricky because not all tickets on the
spreadsheet need to be copied.

The issue is I receive the spreadsheet from another workgroup and they have
merged cells and have the data going down one column, 19 rows.  I can copy,
paste special within Excel to get the data formatted right, then copy it into
Access.  I am hoping there is an easier way.

Any suggestions?

Thanks!
Jim

Jim -A copy/paste special in Excel sounds easy enough.

Jim -

A copy/paste special in Excel sounds easy enough.  You do not have that
option in Access.  If this is a repetetive process, then I would suggest a
macro in Excel to clean up the data, putting it into an empty worksheet.
Then you could import or copy/paste from that into Access.

--
Daryl S