Exporting To SQL Server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
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
 
Back
Top