trouble importing into access

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

Guest

I'm running Access 2003. Trying to import two files, either CSV or XLS.
Access allows me to select the file type, location and so-on. However when
I've selected the file (either double click or "import) the dialog box
disappears, and no import! Tried this from a couple of Db's with same result.
However, I can import a table from another MDB. Also, when I click on a
linked table, it opens fine, but "Linked Table manager" does not open. I am
not getting any error messages!

I've recently had a new pc, but the configuration "claims" to be identical
to my old setup. I've tried checking my Office setup, but it is set to run
everything from my computer, and tells me I have nothing more to add. Any
help would be appreciated, as up until a week ago everything worked fine!

thanks

Dave
 
Hi Sadjonvee,

The first thing to try is to re-register the file ACCWIZ.DLL.

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.

If that doesn't to the trick, register the following files too
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.




If the import/export wizards don't work at all, re-register ACCWIZ.DLL
 
I would reccomend using Access Data Projects and then you're not
subjected to this type of crap-out

MDB is lame and obsolete.

Access Data Projects support thigns like DTS and Bulk Insert / BCP.
Access MDB is too buggy for real-world use.

-Aaron
 
I'm running Access 2003 and I need to know how import a file that the
extension is .DBF. Who cann help me...



"Sadjonvee" escreveu:
 
File|Get External Data|Import...

If you get a message

The Microsoft Jet database engine could not find
the object 'xxx'. Make sure the object exists...

try renaming the file so its name is no more than 8 characters long,
e.g. rename
My Long File.dbf
to
Myfile.dbf
 
Back
Top