data import from excel to access
Posted on 2002-04-30
i want to make such interface that first choose the database whether MS Access or SQL Server where data hast to be imported from excel file.Then according to the database selected, choose access file or sql database.After that choose the table (assuming that the fields in the excel file and fields in access or sql server table are same)then choose the excel file from which data has to be imported to the access file or sql databse.
while importing data the care should be taken that if there are any changes in the existing records in excel those have to be updated in the access file or sql database.And the new records should be appended. while updating ask the user that "data already exists, do u want to overwrite or not" like yes, yes to all, no, no to all msgbox.
how can it be done using class because this has to be done in ASP again. In ASP we cannot get the message box and all so it would be great if you could send me codes for this problem.If possible could you please send me the ASP codes for the same.
i need to make it as component later.could you please tell me how can i make this a component.
hope to hear shortly