can't open *.dbf in Excel

R

ranvir

File created on NT using PowerBuilder in dBaseIII format.
then FTP to UNIX and then using SendMail sent to email
address.
Can't open this .DBF file using Excel 97 or 2000. It give
error: Can not open Protected File.

Any idea or suggesion,
Thanks,

Ranvir
 
G

greg mansius [MSFT]

I found the following in an <old> KB article for much earlier versions of
Excel, but I don't know if it still applies to Excel 97/2000 or even to your
scenario.

CAUSE
=====

This error may occur if the first three characters in a tab-delimited
text file are, in the following order:

(C or K)(any character)(return/line break)

For example, any of these sequences may cause an error:

CA KT Cz Ku C9 K@

Note that this problem is case sensitive: "c" and "k" (lower case) do
not cause the error to occur.

This sequence signifies to Microsoft Excel that the file being opened
is a dBASE file. If the file is not truly a dBASE file, Microsoft
Excel will be unable to convert the file into a usable format, and an
error message will be displayed.

WORKAROUND
==========
To open a tab-delimited text file with a filename that begins with the
characters "C" or "K":
1. Open the file in a text editing program, such as Notepad
2. Replace the "C" or "K" with any other character.
3. Save the file in its original format.
4. In Microsoft Excel, open the file.

Hope this helps.
 

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