Prev: TransferSpreadheet: Importing a Specific Spreadsheet
Next: Field availability dependant on combo box choice
From: Jim on 20 Jan 2010 09:05
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


From: Daryl S on 20 Jan 2010 13:48
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.

--
Daryl S


"Jim" wrote:

> 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
>
>
 | 
Pages: 1
Prev: TransferSpreadheet: Importing a Specific Spreadsheet
Next: Field availability dependant on combo box choice