I need to create a button on my asp.net web page which will take the data from a table in MS access database (on the hard disk or a cd or a floppy) and export it to a table in SQL server 2000 database. Both the tables have the same fields etc.
I have no clue how to go about it. Can anyone guide me in the right direction and tell me how to do this?
Thanks a lot.