First, please refer to this page if you don't know what I'm talking about: http://support.microsoft.com/default.aspx?scid=http://suppor t.microsoft.com:80/support/kb/articles/Q195/9/51.asp&NoW ebContent=1
Ok so, I got a headache from that article so I don't really know how to use that thing. What I need is a page in ASP that queries an Excel data file and imports all the data into an existing Access mdb file. Also, I need to consider the possibility that most records will already exist in the mdb file so I just want to update those according to what's in the Excel file. But new entries should be considered as well.
Any ideas?
Thanks.