Data transfer from access to sql


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: Data transfer from access to sql

  1. #1
    Adolfo Guest

    Data transfer from access to sql


    I need to know what could be the best way to transfer data from a access database
    to and sql type database but the style of the sql database is diferent from
    the other database like the tables have diferent names etc..
    HELP......
    I need some ideas

  2. #2
    Qbert Guest

    Re: Data transfer from access to sql


    The easiest way that I can think of would be to use an ODBC connection into
    your alternate database and use Access queries to do inserts into the appropriate
    tables.

    you could also upsize the Access database and then write a Stored Procedure
    to do the data migration using "select into"

    "Adolfo" <yeb@mail.intec.edu.do> wrote:
    >
    >I need to know what could be the best way to transfer data from a access

    database
    >to and sql type database but the style of the sql database is diferent from
    >the other database like the tables have diferent names etc..
    >HELP......
    >I need some ideas



  3. #3
    G D Guest

    Re: Data transfer from access to sql


    If you are using SQL Server 7 or SQL Server 2000 and you just want to import
    data into existing tables (e.g. you don't want to transfer schema objects).
    Simply run the 'DTS Import Wizard'. This allows you to perform 'transformation'
    operations - a simple way of altering the source data to produce the desired
    target data whilst transferring.

    Cheers,

    GD


    "Adolfo" <yeb@mail.intec.edu.do> wrote:
    >
    >I need to know what could be the best way to transfer data from a access

    database
    >to and sql type database but the style of the sql database is diferent from
    >the other database like the tables have diferent names etc..
    >HELP......
    >I need some ideas



  4. #4
    Gerard Coppejans Guest

    Re: Data transfer from access to sql


    "Qbert" <luke_davis_76@hotmail.com> wrote:
    >
    >The easiest way that I can think of would be to use an ODBC connection into
    >your alternate database and use Access queries to do inserts into the appropriate
    >tables.
    >
    >you could also upsize the Access database and then write a Stored Procedure
    >to do the data migration using "select into"
    >
    >"Adolfo" <yeb@mail.intec.edu.do> wrote:
    >>
    >>I need to know what could be the best way to transfer data from a access

    >database
    >>to and sql type database but the style of the sql database is diferent

    from
    >>the other database like the tables have diferent names etc..
    >>HELP......
    >>I need some ideas

    >



  5. #5
    Gerard Coppejans Guest

    Re: Data transfer from access to sql


    "Qbert" <luke_davis_76@hotmail.com> wrote:
    >
    >The easiest way that I can think of would be to use an ODBC connection into
    >your alternate database and use Access queries to do inserts into the appropriate
    >tables.
    >
    >you could also upsize the Access database and then write a Stored Procedure
    >to do the data migration using "select into"
    >
    >"Adolfo" <yeb@mail.intec.edu.do> wrote:
    >>
    >>I need to know what could be the best way to transfer data from a access

    >database
    >>to and sql type database but the style of the sql database is diferent

    from
    >>the other database like the tables have diferent names etc..
    >>HELP......
    >>I need some ideas

    > Here is a Good One,


    Use the sofware named WINSQL
    This is the site where you will find information of it.
    http://www.indus-soft.com/winsql/
    It's a very good and simple sofware without Dll's and library
    It's a simple exe-file of 740 KB and work very fine
    Gerard Coppejans


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