Consulting

Results 1 to 3 of 3

Thread: VBA to Link SQL View Into Access Database

  1. #1
    VBAX Tutor jo15765's Avatar
    Joined
    Oct 2011
    Posts
    281
    Location

    VBA to Link SQL View Into Access Database

    How would I link a sql view into my database? I have found code to do a table, but no code to do a view?
    Go to Heaven for the climate, Hell for the company.
    ~~Mark Twain

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,446
    Location
    Write a query and use that? A query can span multiple tables.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Regular GP George's Avatar
    Joined
    Jul 2004
    Location
    Puget Sound, WA
    Posts
    26
    Location
    You can link to views in SQL Server just the same way you do for tables, if that is your question. I assume what you are asking about is ODBC linking from Access to SQL Server. If that is not correct, please provide more details on what you need and the environment in which you are working.
    Last edited by GP George; 04-26-2014 at 08:49 PM. Reason: syntax
    "We're all in this together."
    -Red Green

Posting Permissions

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