Tech Support Guy banner
Status
Not open for further replies.
1 - 3 of 3 Posts

·
Registered
Joined
·
1 Posts
Discussion Starter · #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.
 

·
Registered
Joined
·
2,059 Posts
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
 

·
Registered
Joined
·
943 Posts
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?
 
1 - 3 of 3 Posts
Status
Not open for further replies.
Top