Importing To Access

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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.
 
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
 
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?
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Top