Need to create a Simple Import routine to upload an Excel file into an MS Access Database which is the backend of our Website. Because there are 4 different files with 4 different formats (columns and rows), we're going to pick only two rows from every file (SIM# and Activated Date). I'll prepare the Files to be imported manually. What we need is that when the file is imported into the database, the system look into the Inventory Tables and change the status from dispatched to activated (in Inventory Table) and insert the the Dealers name on the records (in History Table). The Main page of the website contains one import button. That button needs to be splitted so that when is hitted, the system ask the kind of import that we want to do: a)New SIMS, b) Activations File. Of course, we're going to develop the activations button which is the one that is going to import the info into the Brand History Table.
NEEDS TO BE DONE IN 1-2 HOURS.