How to characterize the import Action

[masoud_sedighy]

In my database, lists are generally revised several times In order to update the database when a new revision is issued, all the imported data should be provided with a Revision Number and a Revision Type. The Revision Number is the last one for the current data. The Revision Type is a letter to characterize the import Action.

CREATION OF A NEW ELEMENT                    C
DELETION OF AN EXISTING ELEMENT            D
MODIFICATION OF AN EXISTING ELEMENT     M

List of import file fields in excel is like below:

1- Revision Number (numeric)

2- Revision Type (text) ---"C" OR "M" OR "D"---

3- Item Number (text,PK)

4- Old Item Number (text) -- Only when Item Number has been modified—



5- Item Name (text)

6- Item Type Code (text)

Now I like to import this excel file to my table in Access database but I have problems:

1- How I have to design my table in access, I must have the same fields of excel file also in access table

2- How I have to manage these actions , for example some row in my excel file is for creating by "C" character, some rows are for modification of item number with "M" character and also some rows are for deleting item number by "D"

Please help what is the solution, I like to browse this excel file and then pressing import button on my form and data imported according to Revision Type

[June7]

You have to run 3 SQL actions:

INSERT

UPDATE

DELETE

Easiest approach is to set a link to Excel sheet and treat the link just like a table. Use the link as the source for the 3 SQL actions. Assumes the Excel sheet structure is compatible for a link.