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

How to transfer data between Access to SQL 2005

P: 42
Hi All,

I need to retrieve data from an access database and I need to update this into a MS SQL 2005 on a monthly basis(Needs only once in a month, let it be 1st of every month). What I need to do? Do u think I need a console application. I am using ASP.NET c# and SQL 2005. Thanks in advance.

Siju.
Nov 26 '08 #1
Share this Question
Share on Google+
3 Replies


ck9663
Expert 2.5K+
P: 2,878
Two ways:

Create your code in Access and connect directly to your SQL Server and do the necessary update.

or

Create your code in SQL Server and connect to your Access to update your tables.


-- CK
Nov 27 '08 #2

P: 3
An even easier way maybe is to use a tool built for this purpose like this one :
DMC - Convert Migrate Clone Transfer Visualize your data from any source to any destination

It will let you clone the access table even and then transfer the data after doing all your mappings
Nov 30 '08 #3

100+
P: 153
download SSMA and forget everything.
Download details: SSMA 2005 for Access V4.0
Dec 19 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.