Possible to select specific excel cells to import?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Angela - 28 Feb 2006 18:02 GMT

I wish to import specific cells from diffferent excel documents in a specific
sheet. The location of these cells are constant.

Is it possible to make use of TransferSpreadsheet and in that case how
should i configure it ?

Reply to this Message

John Nurick - 28 Feb 2006 18:30 GMT

Hi Angela,

Can you give us a clearer idea of what you need to do? Is the idea to
collect data from various cells in a workbook and assemble them into a
single record in an Access table, then repeat the process with another
workbook? Do you have any control over the workbooks (e.g. if they're all
made from a template, can you modify the template?)?

>I wish to import specific cells from diffferent excel documents in a
>specific
> sheet. The location of these cells are constant.
>
> Is it possible to make use of TransferSpreadsheet and in that case how
> should i configure it ?

Reply to this Message