In a similar situation, I Import the excel files, and Scan-Endscan the tables, but it will depend on that the excel files have the same format ecery time, of course. Another solution is automation.
>Hi Tore
>
>The problem I have is that I want to pick out certain cells on a worksheet i.e. A3, D4, E8 and then populate a paricular record in another table. For example the value of A3 will populate my Cost2.date field in my cost2 table. There is already data in this record in the cost2 table so I would seek for the record first.
>
>Is there a tool to use just like the Excel automation one I used to populate excel?