+ Reply to Thread
Results 1 to 4 of 4

Unlinking tables

  1. #1
    Registered User
    Join Date
    12-13-2013
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    78

    Unlinking tables

    Trying to import tables into a new Database. They come in as linked tables. this creates problems. The db is saved on a shared folder but the linked tables are on a folder that only I have access to.

    How do I import the tables as unlinked? Access 2000

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Re: Unlinking tables

    What are the steps you are currently employing? Are you using an Access Wizard, VBA or some other method. Show us your steps.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    12-13-2013
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    78

    Re: Unlinking tables

    Figured it out.

    I was importing "linked" tables. Need to watch how many versions of a DB I make.
    Last edited by PLD60; 03-15-2018 at 11:49 AM.

  4. #4
    Registered User
    Join Date
    09-13-2012
    Location
    Las Vegas, USA
    MS-Off Ver
    Excel 2016
    Posts
    10

    Re: Unlinking tables

    I remove several items when importing data into Excel.

    Tables
    Connections
    XMLmaps (if used)


    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Linking/unlinking chart Assistance Please
    By jam320 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-25-2014, 05:59 PM
  2. Unlinking results between sheets. NEED HELP
    By wahbert in forum Excel General
    Replies: 1
    Last Post: 01-20-2014, 02:49 PM
  3. unlinking the connections between 2 or more pivot tables
    By ANS in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-11-2013, 04:47 AM
  4. [SOLVED] Unlinking from formula
    By controlfreak in forum Excel General
    Replies: 3
    Last Post: 05-09-2012, 04:25 AM
  5. Unlinking Imported Data
    By Donquick in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-15-2007, 09:29 AM
  6. [SOLVED] Copying and 'unlinking' a chart
    By rmellison in forum Excel General
    Replies: 2
    Last Post: 11-08-2005, 10:35 AM
  7. Unlinking from another Excel Workbook
    By svarnell64 in forum Excel General
    Replies: 3
    Last Post: 08-25-2005, 07:05 PM
  8. Unlinking between workbooks
    By svarnell64 in forum Excel General
    Replies: 1
    Last Post: 08-25-2005, 02:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1