+ Reply to Thread
Results 1 to 3 of 3

How to convert "Excel table" to range without loosing data connection to access ?

  1. 09-20-2013, 04:13 AM #1
    Pettr
    Pettr is offline
    Registered User
    Join Date
    06-09-2011
    Location
    Prostejov, Czech Republic
    MS-Off Ver
    Excel 2010
    Posts
    5

    How to convert "Excel table" to range without loosing data connection to access ?

    Does anybody has any idea how to convert "Excel table" to a range without loosing data connection to access ?

    Petr
    Reply With QuoteRegister To Reply
  2. 09-20-2013, 07:21 AM #2
    ARGK
    ARGK is offline
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: How to convert "Excel table" to range without loosing data connection to access ?

    Hi Petr
    An Excel Table "IS" can be used as a Range so why do you feel you need to change it?
    Tony
    Reply With QuoteRegister To Reply
  3. 09-23-2013, 02:33 AM #3
    Pettr
    Pettr is offline
    Registered User
    Join Date
    06-09-2011
    Location
    Prostejov, Czech Republic
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: How to convert "Excel table" to range without loosing data connection to access ?

    Hi Tony,
    I am not able to share "Excel table". Get a message to convert it to range :-(
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot Table - How to "add a data column" "of the same field" "across multiple sheets"
    By virsilens in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  2. [SOLVED] Excel 2007 "security alert - data connection" message every time?
    By michael.monaco in forum Excel General
    Replies: 2
    Last Post: 12-20-2012, 02:24 PM
  3. Convert Pivot Table data to "regular" format
    By bronsonb in forum Excel General
    Replies: 1
    Last Post: 02-24-2011, 12:24 AM
  4. Query Table "Connection" Prevents Excel from Quitting
    By Grasshopper in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2006, 12:25 PM
  5. "Fall down" a VBA created Pivot Table from data Access
    By Radke in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-06-2005, 07:20 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1