1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Importing To Access

Discussion in 'Business Applications' started by BOB TURNER, Nov 21, 2001.

Thread Status:
Not open for further replies.
  1. BOB TURNER

    BOB TURNER Thread Starter

    Joined:
    Nov 21, 2001
    Messages:
    1
    Hi,
    I cannot import an Excel '97 file to a table In Access '97.

    In the Import dialogue box the "files of type" dropdown list only gives me 2 file types to choose from. They are:

    *Microsoft Access(mdb,mdw,mda)
    *ODBC Databaes()

    I have tried to add additional file types from service packs with no success.

    Is there any solution.

    Bob.
     
  2. jbcalg

    jbcalg

    Joined:
    Oct 29, 2001
    Messages:
    2,056
    is this new, were you able to import before?

    i thought it was standard, use that feature all the time (using off2000 now, forget the off97 stuff, but used it in both versions)

    perhaps that option wasn't loaded properly the first time, or not ticked off

    try putting the cd back in and looking at the repair or add new components (or something similar), also make sure it's checked off to run from the computer not the cd
     
  3. downwitchyobadself

    downwitchyobadself

    Joined:
    Oct 13, 2000
    Messages:
    941
    We just had this thread the other day (you can see it here, but I've never seen the problem before, and clairw reformatted before we could get very far.

    You might try as jbcalg suggested, and also the clean reinstall of Office Dreamboat and I mentioned in the other post. Microsoft (still) has nothing to say about it; I suspect it's ODBC drivers gone bad, but can't reproduce the problem, so... Not that we won't try to solve it, though :)!

    Other questions: What's your OS? Is anything else acting up? Can you export from Excel into Access? Can you save a query as an Excel file?
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/59252

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice