Paste Special, Values, Transpose

[Jim]

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've
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'm hoping there's an easier way.

Any suggestions?

Thanks!
Jim

 

[Daryl S]

Jim -

A copy/paste special in Excel sounds easy enough. You don't 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.