Results 1 to 2 of 2
  1. #1
    thkly8 is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2011
    Posts
    2

    How do i export a Microsoft SQL Server backend system into Microsoft Access?

    Hi there. This is my first post so i hope i haven't left anything out!

    I've just started working at this small charity organization and one of the first things they want me to do is make them a Microsoft Access system (easy enough).
    But one of the problem is, is that they already have a system made by someone else a couple of years ago which is pretty buggy. The system used a backend Mirosoft SQL Server Express 2000 and i need to export all the data from there into Access.
    I was wondering if anyone had any advice as to how i could gain access to the backend of the system so i could transfer that data.



    Thanks

    Tony

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,629
    Google: access link to sql server

    Does this help http://office.microsoft.com/en-us/ac...010200494.aspx
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Microsoft Access help
    By oliverwatson1 in forum Access
    Replies: 8
    Last Post: 03-06-2011, 05:36 PM
  2. Export table from Oracle to Microsoft Access 2007
    By dba in forum Import/Export Data
    Replies: 1
    Last Post: 02-25-2011, 07:05 AM
  3. Replies: 0
    Last Post: 10-13-2010, 03:28 PM
  4. Replies: 3
    Last Post: 10-11-2010, 10:23 PM
  5. Microsoft access
    By rose rivera in forum Access
    Replies: 0
    Last Post: 08-28-2008, 05:51 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 - Senior Forums