Moving data from MS Access to SQL Server programatically


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: Moving data from MS Access to SQL Server programatically

  1. #1
    Join Date
    Mar 2008
    Posts
    2
    Moving data from MS Access to SQL Server programatically ( .NET)

    Edit by admin: no contact info permitted on the forum, thank you

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    Split into its own thread

    Welcome to DevX
    Quote Originally Posted by nkumar
    Moving data from MS Access to SQL Server programatically ( .NET)
    Assuming this is a question, what have you tried so far?

    What version of Access? What version of SQL Server? Has the database in SQL Server been setup with all the proper tables and fields?
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  3. #3
    Join Date
    Dec 2003
    Posts
    2,750
    There are several ways to do this but you could provide a little bit more information. The following link has a code example which implements SQLBulkCopy:

    http://forums.microsoft.com/MSDN/Sho...45989&SiteID=1
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  4. #4
    Join Date
    Mar 2008
    Posts
    2
    I have MS acces 2003 and sql server 2005 Express edition
    Just want to move data only to and from

  5. #5
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    Is this going to be a one time shot, or is this something you will be doing on a regular basis?

    Did you look at the BulkCopy suggestion of pclement?
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

Similar Threads

  1. Replies: 0
    Last Post: 08-16-2005, 10:48 AM
  2. Replies: 3
    Last Post: 07-25-2005, 08:11 AM
  3. Connect SQL Server Box to Oracle Box
    By Mark in forum Database
    Replies: 5
    Last Post: 07-15-2002, 10:24 AM
  4. access vs SQL Server
    By Ray Clough in forum Database
    Replies: 7
    Last Post: 09-06-2001, 02:27 PM
  5. Access to SQL server
    By Nate in forum Database
    Replies: 29
    Last Post: 05-09-2001, 10:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center