I need to automate the import of an excel spreadsheet into two tables separating column A to G in one table(clients) and G to IV(x230 fields) in another table(scores). The row is the match(client name) between the two tables.

I cannot massage the data in excell before import as the client will be importing changes daily via a script.

I have got a solution but its dirty and slow. i.e. concatenate 230 fields of score data into a global field and use 'MiddleWord' to get it into separate fields in the scores table

done either by:

1) using a copy entire layout into a single field -but this does not work on osx

2) copy(imported score) >goto next field(tab order)> paste(without selecting into global concatenated field)>goto next field (next imported score field) >looped x230

There must be a cleaner solution -like being able to specify a set field using a calculation?

ta

--

Rafal

Edited June 22, 200817 yr by Guest

It's not quite clear what you want as the end result. My guess would be you'd want to split the 230 fields into separate records (one for each score), but you speak of concatenation?