Get External Data (import)

[bill]

When selecting Get External Data in Access 2003, I don't see all the file
extension types as an option to import. For example, I do not have the
option to select an Excel file to import.

Any help is appreciated.

 

[Guest]

Hi Bill,

This is likely due to not doing a full installation, when you first
installed Office 2003. Find your installation CD and use the Add/Remove
components option to add any missing components.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

When selecting Get External Data in Access 2003, I don't see all the file
extension types as an option to import. For example, I do not have the
option to select an Excel file to import.

Any help is appreciated.

 

[John Nurick]

The following steps usually fix this and similar problems. If they
don't, or if the files referred to below don't exist, it may be
necessary to install stuff.

f the import/export wizards don't work at all, or if you get "No object
in this control" re-register ACCWIZ.DLL.

If it's one or more file formats that aren't listed, re-register the
following files
msexcl40.dll (Excel)
msxbse40.dll (dBase)
mspdox40.dll (Paradox)
mstext40.dll (Text, CSV, tab-delimited))
In Access 97, the filenames contain 35 instead of 40.

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder.

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.

 

[bill]

This fixed the problem....thanks.

The following steps usually fix this and similar problems. If they
don't, or if the files referred to below don't exist, it may be
necessary to install stuff.

f the import/export wizards don't work at all, or if you get "No object
in this control" re-register ACCWIZ.DLL.

If it's one or more file formats that aren't listed, re-register the
following files
msexcl40.dll (Excel)
msxbse40.dll (dBase)
mspdox40.dll (Paradox)
mstext40.dll (Text, CSV, tab-delimited))
In Access 97, the filenames contain 35 instead of 40.

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder.

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.

 

[Guest]

Will re-registering the ACCWIZ.DLL file so I can do imports in new databases
I create in Access 2003 in anyway impact/affect the Access 2000 databases
that I am not yet ready to convert to 2003?

Thanks,
Marty

 

[John Nurick]

Hi Marty,

If you're using Access 2003, I don't see how it can. If you have more
than one version of Access on your computer, see
http://support.microsoft.com/kb/828956/

 

[Guest]

Thanks so much for the information John! It worked and I am one very HAPPY
camper!

 

[Guest]

I had the same issue and John's instructions worked for me as well..
Thanks!!