467,915 Members | 1,234 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

How to transfer data between Access to SQL 2005

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.

Nov 26 '08 #1
  • viewed: 3644
3 Replies
Expert 2GB
Two ways:

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


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

-- CK
Nov 27 '08 #2
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
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.

Similar topics

6 posts views Thread by StephenMcC | last post: by
2 posts views Thread by Andy Davis | last post: by
5 posts views Thread by teser3 | last post: by
5 posts views Thread by Tom | last post: by
8 posts views Thread by bryan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.