Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Oct 2006
    Location
    Melbourne, Victoria, Australia
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SQL to Access (2003)

    Hi all, just a quick question that a colleague of mine asked me....is it possible to convert Access back-end tables from SQL back into Access? Thanks, Van

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: SQL to Access (2003)

    You can use File | Get External Data | Import... to import SQL Server tables into an Access database. Then either use the linked table manager to point the linked tables to the imported tables, or delete the linked tables and rename the imported tables appropriately.

Posting Permissions

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