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 |
|
winwin
Starting Member
3 Posts |
 Posted - 2006-09-20 : 00:28:07
|
| Hi,I'm new to SQL server, and I would like to achieve below tasks. Kindlyprovide brief guildline on how to achieve these:1.) I have managed to schedule job in SQL server to download the access database from remote server.2.) Second, I would like to transfer all the data from my acccess database to my SQL tables.May I know how do I achieve my task no 2???? I believe I need to write some script (procedure) in order to achieve this.pls advise.... |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-09-20 : 01:42:39
|
| There is an Upsizing Wizard in Access that will allow you to copy your data to SQL Server, but this will try and create the tables too. I would take your MDB file (containing your Access-level tables) and:-link in the SQL Server versions of these tables (e.g. so you would end up with table1 and dbo_table1 - the linked table)-write a VBA script that does an INSERT statement between the Access and SQL versions. In a nutshell, this allows your Access database to see both the Access tables and the SQL Server tables. Then you just copy the data between them. You should be able to create a generic script that copies the data (INSERT INTO dbo_table SELECT * FROM table)HTH,Tim |
 |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2006-09-20 : 06:42:02
|
| Try the DTS Wizard.[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
|
|
|
Transfer Data from Access Database to SQL Server