Exporting To SQL Server

[brian]

I created a quote program for my salesman to generate and store information in Access 2000. At the end of the day when they are back at the office I would like for them to be able to click an export button to take all the quotes for the current day and update a SQL Server 2000 table. I need help determining how I should go about. I have my update query but need to know how to connect Access 2000 with SQL server 2000 and allow the update query to update the SQL databas

Thank

If anyone needs more information please ask

 

[Spink]

Create a DTS package to move the data from Access to SQL
and then schedule a job to run the DTS package.

-----Original Message-----
I created a quote program for my salesman to generate and

store information in Access 2000. At the end of the day
when they are back at the office I would like for them to
be able to click an export button to take all the quotes
for the current day and update a SQL Server 2000 table. I
need help determining how I should go about. I have my
update query but need to know how to connect Access 2000
with SQL server 2000 and allow the update query to update
the SQL database