Can only import from Access DB and OBDC DB's

[Jack]

When I try to import or Link to tables the only options
that I have are Access and the OBDC drivers. I used to be
able to link to Excel and other types of files. Any help
on what happen and how do I fix it.


Thanks a million

 

[Douglas J. Steele]

This sounds like the problem discussed in
http://support.microsoft.com/default.aspx?scid=kb;[LN];155666
http://support.microsoft.com/default.aspx?scid=kb;[LN];171955
http://support.microsoft.com/default.aspx?scid=KB;[LN];209805

You don't mention what version of Access you're using.

For Access 97, look for the files msexcl35.dll, msxbse35.dll, mspdox35.dll
and mstext35.dll on your hard drive (they should be in the System folder).
Use regsvr32.exe to register them

For Access 2000 or 2002, look for:
Msexcl40.dll (Microsoft Excel)
Msexch40.dll (Microsoft Exchange)
Msltus40.dll (Lotus 1-2-3)
Mspbde40.dll (Imprise Paradox)
Mstext40.dll (Text)
Msxbde40.dll (Dbase)

 

[Jack]

Thanks A Million!!!
The last artice solved the problem.

-----Original Message-----
This sounds like the problem discussed in
http://support.microsoft.com/default.aspx?scid=kb; [LN];155666

http://support.microsoft.com/default.aspx?scid=kb; [LN];171955
http://support.microsoft.com/default.aspx?scid=KB;

[LN];209805

You don't mention what version of Access you're using.

For Access 97, look for the files msexcl35.dll, msxbse35.dll, mspdox35.dll
and mstext35.dll on your hard drive (they should be in the System folder).
Use regsvr32.exe to register them

For Access 2000 or 2002, look for:
Msexcl40.dll (Microsoft Excel)
Msexch40.dll (Microsoft Exchange)
Msltus40.dll (Lotus 1-2-3)
Mspbde40.dll (Imprise Paradox)
Mstext40.dll (Text)
Msxbde40.dll (Dbase)


--
Doug Steele, Microsoft Access MVP

When I try to import or Link to tables the only options
that I have are Access and the OBDC drivers. I used to be
able to link to Excel and other types of files. Any help
on what happen and how do I fix it.


Thanks a million

.