Convert excel 97 file to access 97

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.

poggy

Thread Starter
Joined
Jan 10, 2002
Messages
7
We used to be able to open excel files in access, however now the extension type .xls is not available in the file extension box under open. It wont let me drag and drop excel docs into access either. i get the impression that i need to use the odbc function under control panel but i cant seem to get any joy, has ne1 got any pointers??
cheers
 

poggy

Thread Starter
Joined
Jan 10, 2002
Messages
7
sorry that didnt work,

it looks like all the components arent installed and we are restricted in the office to what we can install, so is there a website where we can download the required files for conversion?
 
Joined
Jun 26, 2000
Messages
7,762
Originally posted by poggy
sorry that didnt work,
Sorry about that. I didn't think it was the actual resolution, but I took a stab.

I could find no info on Access suddenly being unable to open Excel files. My other recommendation would be to reinstall Access, but you said
it looks like all the components arent installed and we are restricted in the office to what we can install, so is there a website where we can download the required files for conversion?
.

Are you running under NT and are not the administrator? That is the only way I can figure that you would be restricted in installations, unless you are referring to the fact that you no longer have the CDs to do a reinstall.

Was anything done to the machine to make it suddenly stop being able to open Excel files through Access? Any other software loaded, or updates done?

Hopefully, someone else will jump in and offer a solution.
 

poggy

Thread Starter
Joined
Jan 10, 2002
Messages
7
the link you provided did give the solution, the problem was that the dlls on my computer werent working (god knows why) so i had to use regsvr32.exe to get them to register with access. not quite sure why all this worked or even why the thing went bust to begin with. but at least its sorted now.

cheers
 
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

Members online

Top