Closed Thread
Results 1 to 2 of 2

Use Access data w/o importing

  1. #1
    Registered User
    Join Date
    08-23-2010
    Location
    St Paul, MN
    MS-Off Ver
    Excel 2007
    Posts
    2

    Use Access data w/o importing

    Hi folks-- Just wondering if there is any way that I can use data from an Access table in my Excel functions without importing the Access data into the wookbook.

    I set up a connection to the Access table that I need, but don't know what the syntax would be to reference those fields in functions in my Excel sheet (or if it's even possible).

    My problem is that the Access table is large and I want to keep the size of the Excel workbook small.

    Thanks!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Use Access data w/o importing

    Cross-posted at http://www.ozgrid.com/forum/showthre...d=1#post519137
    Entia non sunt multiplicanda sine necessitate

Closed Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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