Posted by Takuon Soho on 09/30/79 11:16

I'm taking over an SQL Server
database which is often updated
with data from an Access database.

Knowing little about either, this
simple task has become a challenge.

I'm told that the previous person
used to type some simple SQL
commands and this would update
the SQL server database but the
commands have been lost and the
previous person is unavailable.

The Access database has exactly
the same column names as the SQL-server database
and it is something simple
like:
Control ID Phone Name Address1 Address2

Does anyone know the SQL commands
to do this kind of SQL server database update from the
above mentioned Access database?

The previous person left an app which connects
the two databases and leaves a place
where the SQL commands are to be typed.

Thanks
TAK

• Next in forum: How to assign quota on a specific datafile?
• Prev in forum: Re: Extended stored procedure performance tuning
• Thread view: Updating SQL Server Database from Access

[Reply to this message]