By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,148 Members | 765 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,148 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"BUSHII" <pi****@robcom.com.pl> wrote in message news:<cd**********@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
Jul 20 '05 #2

P: n/a
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" <pi****@robcom.com.pl> wrote in message
news:cd**********@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

Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.