CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. May 25th, 2001, 06:44 AM #1
    yrf9320
    yrf9320 is offline Member
    Join Date
    Sep 2000
    Posts
    36

    SQL Server to MSAccess

    How can I convert a SQL Server database to an MSAccess database.

    Reply With Quote Reply With Quote
  2. May 25th, 2001, 06:57 AM #2
    dave seddon
    dave seddon is offline Junior Member
    Join Date
    May 2001
    Location
    Lancashire, England
    Posts
    16

    Re: SQL Server to MSAccess

    On SQL Server Enterprise manager (SQL Server 7), under the Tools menu is the option Data Transformation Services. This allows you to export data to a variety of databases, etc.

    Alternatively, link from a blank Access database via ODBC to the SQL Server tables you want and qrite a few Make table queries that suck in the desired tables.

    Hope this helps

    Dave Seddon

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured