Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009
    Posts
    1

    Question Import from SQl server

    I want to import complete database schema (tables with keys, views ) from SQL server to ms-access.

    1) there any tool avialable from MS-Access side or from sql server side?


    2) how to import stored procedures fromm sql server to access? any tool?


    Sqlserver version: 2005
    MS-Access version: 2003/2007


    Thanks
    --
    Rajesh A
    S7 Software

  2. #2
    rommelgenlight is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Mar 2009
    Posts
    77
    why do you want to import to ms access from sql?

  3. #3
    Tgrou is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2009
    Posts
    8
    What I could suggest is looking at a tool that will allow you to perform the migration from SQL server to Access. You could look into using an ETL tool designed for IT professionals, usable by non-technical users: Talend Open Studio. You can perform the migration as well as other tasks ETL tools will allow you to do.
    Components have been created to link the Access database to SQL.

    For more information: http://www.talend.com/

    ---

    Talend Open Studio is an open source ETL tool for data integration experts with a user-friendly GUI, easy to learn for a non-technical user. What distinguishes Talend, when it comes to business users, is the tMap component which allows the user to get a graphical and functional view of integration processes.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 03-09-2009, 12:20 PM
  2. Access / SQl Server Advantage.
    By caljohn527 in forum Queries
    Replies: 0
    Last Post: 01-24-2009, 06:40 PM
  3. Replies: 0
    Last Post: 11-04-2006, 02:31 AM
  4. sql server active x - HELP!!!!!!!!!!!!!!
    By Valeda in forum Access
    Replies: 0
    Last Post: 06-27-2006, 01:02 PM
  5. Unique Record Identifier for MS SQL Server Tables
    By MGSP in forum Import/Export Data
    Replies: 2
    Last Post: 01-29-2006, 03:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums