AnsweredAssumed Answered

import data from excel for different companies using drop down list

Question asked by EricSommeling on Jun 11, 2011
Latest reply on Jun 13, 2011 by EricSommeling

Title

import data from excel for different companies using drop down list

Post

In my database I have one table with 5 company names and the second table with the details for the people they have contracted, the fields in this table are: Company name, Name, Address, Tel, Amount. Each company has provided an Excel file with the details of the people they have contracted (> 5000 records each), Fields in the Excel sheet: Name, Address, Tel, Amount. Now I want to be able to select the company name from a drop down list and upload (using a script) the Excel data in the second table. I am able to upload the data but without setting the company name I selected from the drop down list. Does anyone has an idea how to do this? any help would be appreciated! Eric

Outcomes