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@hotmail.com]

Re: Updating SQL Server Database from Access


Takuon Soho wrote:[color=blue]
> 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[/color]

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]

Re: Updating SQL Server Database from Access

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

<teddysnips@hot mail.com> wrote in message
news:1116515517 .523660.297510@ o13g2000cwo.goo glegroups.com.. .[color=blue]
>
> Takuon Soho wrote:[color=green]
>> 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[/color]
>
> 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
>[/color]