Sql And access

  • Thread starter Thread starter White
  • Start date Start date
W

White

Hello i have an access database with a similar database with the sql server
and i want to exchange data with an existing database in SQL Server 2005
how can this happen?
Thanks
 
No idea what "exchange data" means in your situation...

Also, if the data is located in two locations, why not just use one of them?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
The access database is going to be sent to other peers and they are going to
sent the data via e-mail and am going to enter them in the SQL Server.So i
need to find a way to do this to update the data in the SQL server
Automatically with the data they input in Access
Thanks
 
Check Access HELP for information about "update queries".

You should be able to link to the SQL-Server tables from Access, and use an
update query to update the values in SQL-Server from the Access tables.

Or if the data is new, you can use "append queries" to go from Access table
rows to (linked) SQL-Server table rows.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top