Copy data

Results 1 to 2 of 2

Thread: Copy data

  1. #1
    Join Date
    Dec 1969

    Default Copy data

    Hi,<BR><BR>I need to copy the data(one full table) from an Access database to a SQL Server.<BR><BR>I knwo this can be done using DTS, but I wanted to do this in my .net code.<BR><BR>Does anybody have a sample of how this can be done using Datasets and DataAdapters?<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Copy data

    I think you should be able to fill a dataset from the access db and then insert this dataset into your sql db with the INSERT command. look this up in google. I saw several code examples.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts