Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shajimanjeri
Posting Yak Master
179 Posts |
 Posted - 2007-04-25 : 01:51:37
|
Hi,I need to migrate my access database to SQL2000 Server. I have three tables in my access database. In each table have 3000-6000 records.So how to put all these records in to sql2000 server tables.The table structure in Access database and sql2000 database are same.Here core work is just insert all these 3000 - 6000 records (rows) from Access database to sql2000 databaseThanks in Advance!!With regardsShaji  |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-25 : 03:59:16
|
| I would ust DTS for this job.Kristen |
 |
|
|
shajimanjeri
Posting Yak Master
179 Posts |
Posted - 2007-04-25 : 04:47:54
|
Hi Kristen,How to proceed this one with DTS. Could you give me a website url name to get more details on this??quote:
Originally posted by Kristen
I would ust DTS for this job.Kristen
|
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-04-25 : 04:55:09
|
| This link can be useful: [url]http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0561.mspx?mfr=true[/url]Also for DTS-specific queries, take a look at: [url]http://www.sqldts.com/[/url]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2007-04-25 : 06:50:43
|
| Similar to http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82616 |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-25 : 10:11:20
|
| Don't forget books online. |
|
|
|
|
|
|
Migrating Access to SQL 2000 server