Microsoft Access to SQL server 2000 script

i am developing a desktop appl with access. Later i need to make an interface that will have a button and which will upload the .mdb file to a SQL server database. The tale structure is already created only the newly entered data needs to be uploaded using the button. Any one has any script of this kind ? Please suggest any resource you can .

hey psychosid! It occours to me..that the application could

1) connect to the SQL server engine.
2) get the data from the .mdb file
3) insert it into the the corresponding table in SQL server.


Tecnically, if arranged that way, all you need script wise would be:
- a simple select to retrieve the values from the .mdb file
- a simple insert to insert the values into SQL server.

Good Luck!

Anibal.

PS: Hope I didn't miss something in my attempt to simplify your task!