Results 1 to 10 of 10
  1. #1
    New Lounger
    Join Date
    Jul 2005
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel and ODBC (Excel 2002)

    Hello - I have a user who has set up an extensive system in Excel using ODBC connections between workbooks. This system has worked for awhile without problems, but now continually corrupts workbooks. Some of the workbooks are accessed by other users, some not. However all are in the same folder on the same network. I have researched and found nothing about using ODBC connections to link workbooks and suspect this is the problem, however my user insists that how she set up her system is a documented process. Everywhere I read, the export to/ODBC feature is to connect to external sources, not to workbook files on the system. Thoughts???

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel and ODBC (Excel 2002)

    Welcome to Woody's Lounge!

    I never use ODBC to link workbooks, I always use link formulas. Does this user have a specific reason to use ODBC?

  3. #3
    New Lounger
    Join Date
    Jul 2005
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel and ODBC (Excel 2002)

    No, the user doesn't have a specific reason, except that this is how she originally set up her system and doesn't want to abandon it. When I explained about using link workbooks, she stated that was too tedious and using the ODBC was easier. I was hoping to either find someone who had used this method, or some documentation showing that this was not the proper usage to convince her to use linked workbooks. Thanks.

    Lori

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel and ODBC (Excel 2002)

    In what sense are link formulas tedious, in her opinion?

  5. #5
    New Lounger
    Join Date
    Jul 2005
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel and ODBC (Excel 2002)

    With the export feature, it makes a duplicate copy that is the same as and is linked to the original. She then manipulates the copy to include different formatting, calculations, etc. for a new "report". This "report" will update anytime she opens it. I have tried unsuccessfully to show her different and more simple methods to accomplish what she needs including pivot tables, etc., but she is reluctant to let go of what she has created and does not want to accept that her process could be causing the problems. I am hoping to come up with some documentation to support my analysis or justify her's. This is one of those unfortunate scenerios where the user asks for help, but won't listen to the answer because it isn't what they want to hear. Thanks!

    Lori

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel and ODBC (Excel 2002)

    I doubt that you will find any official documentation stating that you shouldn't use ODBC to link an Excel spreadsheet...

  7. #7
    New Lounger
    Join Date
    Jul 2005
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel and ODBC (Excel 2002)

    I suspected as much, but thought I would try anyway. I'm assuming that also means there is no documentation on using ODBC connection between Excel workbooks.

    Lori

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel and ODBC (Excel 2002)

    You could try a Google search...

  9. #9
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel and ODBC (Excel 2002)

    I searched the .pdf of the Excel 2003 Bible. In about 900 pages of text, ODBC is mentioned 3 times, all on the same page. The context is in the discussion of utilizing outside databases to work with extremely large amounts of data. There is no mention from what I can see of using ODBC to link to other workbooks. However, just as with the other Bible, I haven't read nearly as much of this book as I should... <img src=/S/innocent.gif border=0 alt=innocent width=20 height=20>

    Don't know if that helps you or not...

  10. #10
    New Lounger
    Join Date
    Jul 2005
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel and ODBC (Excel 2002)

    I'm with you. I've looked in several of my reference books and have come up with zilch. Thanks for checking, I appreciate it!

    Lori

Posting Permissions

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