Importing Excel/TXT (via Get External Data)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I am using the "get external" data command in Access 2002, I am able to select the files excel or text files however upon selecting the file and then importing nothing happens and Access does not import the data from the file

I have attempted re-installing MS Access and have also updated MDAC to version 2.8 however am still having the same problem.
 
Hi Saeed,

If the import/export wizards don't work at all, 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.
 
Back
Top