Get External Data (import)

  • Thread starter Thread starter bill
  • Start date Start date
B

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.
 
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.
 
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.
 
This fixed the problem....thanks.

John Nurick said:
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.
Click to expand...
 
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
 
Back
Top