export (from mdb)-> import (to MS Sql server)

I have big problem.

In database MyDB.mdb I have table for example: ORDERS with colums:
- Id int
- Name varchar(20)

Also I create same table in SQL Server 2k.
I can manualy export this data from mdb database to SQL Server. But I want
to make this more automatic.

Is is possible? To import automaticaly data from mdb format to table in SQL
Server 2000?

please, help me :)

best regards
Piotr Leib

ps.
sorry for my terrible english language"BUSHII" <piotrl@.robcom.com.pl> wrote in message news:<cd3vki$6pk$1@.nemesis.news.tpi.pl>...
> I have big problem.
> In database MyDB.mdb I have table for example: ORDERS with colums:
> - Id int
> - Name varchar(20)
> Also I create same table in SQL Server 2k.
> I can manualy export this data from mdb database to SQL Server. But I want
> to make this more automatic.
> Is is possible? To import automaticaly data from mdb format to table in SQL
> Server 2000?
> please, help me :)
> best regards
> Piotr Leib
> ps.
> sorry for my terrible english language

Have you looked at DTS? It can move data directly between different
data sources. To get started quickly, you can use the "Import and
Export Data" option in the start menu. Another possibility is to
create a linked server from MSSQL to the Access DB, and then simply
INSERT...SELECT... directly - see "Linked Servers" in Books Online.
Finally, if you can export to a flat file from Access, then you can
import that file with bcp.exe or DTS.

Simon|||I just create an ODBC connection to this database server and MS Access can
export directly to ODBC. It even will create the tables for you.

Oscar...

"BUSHII" <piotrl@.robcom.com.pl> wrote in message
news:cd3vki$6pk$1@.nemesis.news.tpi.pl...
> I have big problem.
> In database MyDB.mdb I have table for example: ORDERS with colums:
> - Id int
> - Name varchar(20)
> Also I create same table in SQL Server 2k.
> I can manualy export this data from mdb database to SQL Server. But I want
> to make this more automatic.
> Is is possible? To import automaticaly data from mdb format to table in
SQL
> Server 2000?
> please, help me :)
> best regards
> Piotr Leib
> ps.
> sorry for my terrible english language