Results 1 to 3 of 3

Thread: Excel

  1. Sep 24th, 1999, 01:15 AM #1
    winapi
    winapi is offline

    Thread Starter
    Member
    Join Date
    Aug 1999
    Location
    metairie, la usa
    Posts
    40

    Post

    Hello, I am use to using the RDC object in visual basic to read access databases.
    data.sql="Select * from (Field Name)"
    data.refresh
    is there anyway possible to use the ODBC to link into a Excel spreadsheet and use similar select statements.
    Thanks
    Richard Lange
    Reply With Quote Reply With Quote
  2. Sep 24th, 1999, 02:20 AM #2
    JHausmann
    JHausmann is offline
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105

    Post

    Well, I can set up an Excel DSN, via the ODBC control panel. I have no idea on how I would use it though....
    Reply With Quote Reply With Quote
  3. Sep 28th, 1999, 12:33 AM #3
    Rob Gray
    Rob Gray is offline
    New Member
    Join Date
    Sep 1999
    Location
    Middlesborough
    Posts
    2

    Post

    why not try tackling from a different perspective.


    make a tabke in microsoft query, which you can then access in excel and any other app.

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width