I hope someone can help me with thiis problem

[udikafri]

I hope someone can help me with thiis problem

Hi I have an excel worksheet that does the following every 20 miinuts : 1.delete all data; 2.connect to a specific site on the internet and get new data; 3.save the new file. I need the new data after it has been updated to be ADDED to an existing Access table. my problem is that I can't transfer the data and ADD it to the access table. does any one have an idea on how to do that ? p.s. I think there is an AFTERUPDATE function in excel so if that is true then how do I edit it to write to the access ,because that would solve my problem. thank you all udi

 

[דון פאקטו]

בוא ננסה

על מנת לנסות לסייע, עליך לספר לנו יותר - מה אתה עושה, באילו בעיות אתה נתקל, מה עשית. כשאתה רק מציין I can't, אתה מותיר לנו מקום עצום (מדי) לדימיון.

 

[udikafri]

More details

As I pointed I have an excel worksheet that every 20 minuts delete the current data then gets new data (same coulmns but new data ) and then saves the file. at this point I need it to automaticly ADD the new data to an exisiting access database with one table the header are the same in the acceess table and the excel worksheet. I tryed to do it first by connecting the access table to the excel sheet from the access but then when the data is deleted from the excel it is also deleted from the access I tryed to add to the excel command a dataset to read the data from the sheet and then with an "INSERT INTO" sql command but it does not recogniaze the needed class wich is probbly something I did wrong I was trying to find an AFTER-UPDATE command in excel but didn't find it what I think I need is help with how do I take the new data and add it to the access table p.s. the excel file is open at all time and the access file does not have to be - it's all good thank you in advance udi

 

[udikafri]

Thanks anyway

Thank you don-fackto but I managed to solve my problem