Importing from Excel to Access

  • Thread starter Thread starter Andrew Wood
  • Start date Start date
A

Andrew Wood

I can't seem to import data from Excel to Access, due to
the filetype not being there on the drop down menu, when
selecting the import option.
It used to be there, but since I reinstalled Office, the
option has gone.
It becomes more apparent when I was reinstalling Office,
as there was an error that occurred telling me that it
couldn't install something to the registry, to do with
recognising Excel documents. Its never done this before,
and a reinstall doesn't appear to have any effect.

Any ideas please? Maybe a the registry entry that I'm
missing perhaps.

Thanks
 
Andrew Wood said:
I can't seem to import data from Excel to Access, due to
the filetype not being there on the drop down menu, when
selecting the import option.
It used to be there, but since I reinstalled Office, the
option has gone.
It becomes more apparent when I was reinstalling Office,
as there was an error that occurred telling me that it
couldn't install something to the registry, to do with
recognising Excel documents. Its never done this before,
and a reinstall doesn't appear to have any effect.

Any ideas please? Maybe a the registry entry that I'm
missing perhaps.

Thanks
Click to expand...

Andrew

Have a look at this article on the MS Knowledge Base, which describes
a couple of methods of fixing the problem -
http://support.microsoft.com/default.aspx?scid=kb;en-us;171955

Jon

Access tips & tricks - http://www.applecore99.com
Microsoft Access webring -
http://a.webring.com/hub?ring=microsoftaccess
 
Try re-registering the dll files like this:
Start Run
regsvr32 msexcl35.dll
regsvr32 msxbse35.dll
regsvr32 mspdox35.dll
regsvr32 mstext35.dll

Use 40 instead of 35 for A2K and 2002.
 
This applies to Microsoft Access 2003.

It occurs to me (though I have not confirmed it) that the "Removal Wizard" in the "Microsoft Office 2003 Resource Kit" may be to blame for the lost registry entries. Jon Fallon's solution fixed the "Files Of Type" issue for Excel on my computer (WinXP Pro, Office 2003), but Paradox, dBase, and Outlook/Exchange files still did not appear in the dropdown. I decided to go ahead and register all the drivers at once by inserting the following lines into a batch procedure. After running the batch procedure, the "File/ExternalData/Import" command in Access 2003 presents all expected entries in the "Files Of Type" dropdown.

regsvr32 "C:\WINDOWS\system32\msjet40.dll"
regsvr32 "C:\Program Files\Microsoft Office\OFFICE11\ACCWIZ.DLL"
regsvr32 "C:\WINDOWS\system32\msexch40.dll"
regsvr32 "C:\WINDOWS\system32\msexcl40.dll"
regsvr32 "C:\Program Files\Microsoft Office\OFFICE11\MSJSPP40.DLL"
regsvr32 "C:\WINDOWS\system32\msjtes40.dll"
regsvr32 "C:\WINDOWS\system32\msltus40.dll"
regsvr32 "C:\WINDOWS\system32\mspbde40.dll"
regsvr32 "C:\WINDOWS\system32\msrclr40.dll"
regsvr32 "C:\WINDOWS\system32\msrd2x40.dll"
regsvr32 "C:\WINDOWS\system32\msrd3x40.dll"
regsvr32 "C:\WINDOWS\system32\mstext40.dll"
regsvr32 "C:\WINDOWS\system32\msxbde40.dll"

NOTE: The following lines were excluded from the batch file because they refer to obsolete DLLs
regsvr32 "C:\WINDOWS\system32\MSXBSE35.DLL"
regsvr32 "C:\WINDOWS\system32\mspdox35.dll"

----- Joe Fallon wrote: -----

Try re-registering the dll files like this:
Start Run
regsvr32 msexcl35.dll
regsvr32 msxbse35.dll
regsvr32 mspdox35.dll
regsvr32 mstext35.dll

Use 40 instead of 35 for A2K and 2002.
 
Back
Top