Results 1 to 6 of 6
  1. #1
    Star Lounger skip's Avatar
    Join Date
    May 2002
    Location
    Connecticut, USA, Connecticut, USA
    Posts
    50
    Thanks
    4
    Thanked 0 Times in 0 Posts

    ODBC - Tables not available (Access 2000)

    I've imported a large text file and created a table that will be the source file (via ODBC) for a data import job.
    I've used the default Access ODBC driver and pointed it to the database I've created. Then, as a test, I've attempted an import (get external data/query) into excel.
    Now here's the problem, I can see the database but when I attempt to expand (click the + sign) the database to view the available tables, nothing appears.
    One possible clue. The main table I need to use contains approx. 300,000 rows

    Thanks for the help!!

    Skip
    Skip Whitten, MCITP
    http://www.skipwhitten.info

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: ODBC - Tables not available (Access 2000)

    With a table that large, Excel is going to choke on it - if I recall, 2000 is limited to 32K rows, while 2002 will handle 65K rows. Just out of curiosity, why are you attempting to export it to Excel after you've gotten it into Access?
    Wendell

  3. #3
    Star Lounger skip's Avatar
    Join Date
    May 2002
    Location
    Connecticut, USA, Connecticut, USA
    Posts
    50
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: ODBC - Tables not available (Access 2000)

    Sorry for the confusion. I realize the limitations of Excel. My test was only to verify that there was nothing wrong with the ODBC connection. Attempting to tap the data into Crystal also failed. BTW, Excel will import 65,000 lines then stop if it functions correctly.
    Other databases (.mdb) on my system function properly. Could it be a permissions error?
    Skip Whitten, MCITP
    http://www.skipwhitten.info

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: ODBC - Tables not available (Access 2000)

    Try creating a mail merge in Word that uses the table - you don't need to actually do the merge, just set up Access as the data source and specify ODBC as the data method. If you can't do that, then there are problems of some sort. Unless you have activated User Security for Access, I doubt if it's a permissions problem - if you can open and edit it from Access, then you have the necessary file permissions. It is possible that it is corrupt in some way that blocks ODBC access, but that would be quite unusual.
    Wendell

  5. #5
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: ODBC - Tables not available (Access 2000)

    A couple of other suggestions:

    Permissions - as Wendell said this could be a permissions problem. If the ODBC connection is setup properly and you do not have the correct permissions for where the data is stored, you won't be able to access it. I have gone as far as seeing the tables via odbc but get no results when selecting them for input. This could also be a server problem if you are using a terminal server and the session is "hung" which will also prevent you from getting data even through everything else is fine.

    ODBC - Is the ODBC connection setup properly? Go to control panel, select ODBC Drivers, Configure, and press the TEST button to see if it is working properly.

    Run a test. Try moving the raw data file to your local c drive and create a system or machine dsn to connect to it and then re-try the ODBC import. If it runs locally, then the problem is with your access to the network folder.

    HTH
    Regards,

    Gary
    (It's been a while!)

  6. #6
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: ODBC - Tables not available (Access 2000)

    ... one other item to think about. Is the excel file protected?
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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