Updating SQL Server Database from Access

[Takuon Soho]

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

[teddysnips]

Takuon Soho wrote:

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

My reaction is to familiarise yourself with the DTS (Data
Transformation Services) functionality. I do imports from Access to
SQL Server regularly. It's really simple to set up, but depending on
what you need to do there may be some fiddling about, and you could
struggle a little if you need to write SQL (unless you are familiar
with it!)

Edward

[Takuon Soho]

Thanks, yes that DTS tool looks very powerful.

However, my predecessor used SQL and
that is how I shall do it.

Can you show an example SQL statement(s) which updates
all an SQL-server database with all the rows from an Access database?

Thanks Again
Tak

<te********@hotmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

Takuon Soho wrote:

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

My reaction is to familiarise yourself with the DTS (Data
Transformation Services) functionality. I do imports from Access to
SQL Server regularly. It's really simple to set up, but depending on
what you need to do there may be some fiddling about, and you could
struggle a little if you need to write SQL (unless you are familiar
with it!)

Edward