Access crashes when importing dbf file


S

Steve

I'm using Access 2003 and when I try to import a dbf file, Access crashes on
me. I've already tried repairs and uninstall/reinstall of Office but that
hasn't resolved the issue. I also am up to date on all service packs and
updates. Not sure what to try next.
 
Ad

Advertisements

S

Steve

I want to add that when I say crash, I mean it simply disappears without any
warning or error messages.
 
L

lucas

Steve said:
I'm using Access 2003 and when I try to import a dbf file, Access crashes
on
me. I've already tried repairs and uninstall/reinstall of Office but that
hasn't resolved the issue. I also am up to date on all service packs and
updates. Not sure what to try next.
 
J

Jerry Whittle

Any dbf file or just a particular file? If it's a particular file or file(s),
I'd try to find another dbf file from a different system and try to import it.
 
S

Steve

This is with any dbf file.

Jerry Whittle said:
Any dbf file or just a particular file? If it's a particular file or file(s),
I'd try to find another dbf file from a different system and try to import it.
 
P

Paul Shapiro

Did you also try a different computer? Or importing the dbf to Excel first?
The original dbf format was simply a fixed-length text file. If all else
fails, you could try importing it as fixed-length text. If I remember
correctly, the first character is a blank for a good row and a '*' for a
deleted row. The rest of the row is your data fields.
 
Ad

Advertisements

B

Bob Quintal

I'm using Access 2003 and when I try to import a dbf file, Access
crashes on me. I've already tried repairs and uninstall/reinstall
of Office but that hasn't resolved the issue. I also am up to
date on all service packs and updates. Not sure what to try next.

Make sure the .dbf file name is eight characters or less.
ISTR that the import code balks at long file names on .dbf files.
 
P

Paul Shapiro

Bob Quintal said:
Make sure the .dbf file name is eight characters or less.
ISTR that the import code balks at long file names on .dbf files.

Good point! I'd forgotten that but I also seem to remember now that Bob
mentions it. You might also try a local folder with no spaces in the folder
names, and maybe no more than 8 characters for the folder names too. It's
been a while since trying to remember back to DOS days.
 
S

Steve

Thank you for the responses. This happens with all dbf files and all mdb
files on my computer. It works fine on other computers though so the issue
is just on my computer. Yes, I can import other file formats like Excel
files. So I could bring the dbf into Excel then from Excel to Access,
however, I perform this operation quite often so I would like for it to work.
When Access crashes, it creates the .ldb file and I have to open Access
again and close it for the .ldb to disappear.
And yes, I am using a dbf file w/less than 8 characters in the name and
there are no spaces in the path name...which is local.

If by "linking" you mean opening vs importing the dbf in Access then that
doesn't work either...it also crashes Access.
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top