sending comma separated data to multiple fileds via a push of a button
I am currently using excel to accept comma separated data from a line of text from a web site. Basically I go to the web site, high light the line of text, copy, go to excel, paste the data, which then
gets pasted to different cells in the same row.
I wanted to make a FM user interface that has the embedded web page on a tab, high light the line, copy it, and then paste it to a field, which then would send it to the last row of the database table, ie creating a new record.
Actually I would like to be able paste the data, hit a VERIFY button which would see if the data is already in the table and if it is in the table it would send a popup to the user indicating the data is already present. Otherwise it would notify the user that the data has been successfully added to the data base table.
Does anyone have some insight on this?