Access vs Oracle

[XmatriX]

Hi there,

Need some help please, i created a database using Access 2003, i get my daily info of 2000 tags from an Oracle database, my problem is that i need my charts, reports and my Table to update daily when i run my query, biggest problem is that i cant get to save the new daily info with out overwriting my exsisting data. i need a VB script to excute these commands, as i'm not to clued up in VB, any help will be appreciated.

Thanks
Regards

[janders468]

It sounds like you are overwriting you're data every day? If you need to keep your data then append it to the table instead of overwriting it. If I'm missing something please give me a little more detail.