Page 1 of 1

Clarify previous question

Posted: Sun Nov 28, 2010 1:39 pm
by phillyrob
I have in my Db the table names A, B, C and in each table the fields are: id, date, number_1, number_2 ,number_3.

I take numbers from a spreadsheet and copy them into a text box like so

1-2-3
4-5-6
7-8-9 ect

up to 20 rows of numbers. My script will explode those number delimiting on the "-" and upload each number into the proper field, but I first must select each table, then copy/paste into form then hit submit to upload. I have to do each table separately. I am looking to have an array with the each table name, and when i copy the numbers into form, have each row be associated with each element of the array (table name) ie

table A matched with first pasted number 1-2-3
table B with second 4-5-6 and so on.

and upload each number into the proper table