software

Why does my file go blank when saved as a .dbf

In my simple testing in xl2003, my file didn't go blank.

You may want to post more details on what you did--and what version of excel
you're using.

(and what version of .dbf, too.)

lelykg wrote:
gt;
gt; Why does my file go blank when saved as a .dbf

--

Dave Peterson

My version of excel is 2002 on xp pro
The files contents always disappear without having to open the dbf with
visual foxpro 9.0
I would open the file saved as a .dbf in excel after saving and it would be
blank in excelquot;Dave Petersonquot; wrote:

gt; In my simple testing in xl2003, my file didn't go blank.
gt;
gt; You may want to post more details on what you did--and what version of excel
gt; you're using.
gt;
gt; (and what version of .dbf, too.)
gt;
gt; lelykg wrote:
gt; gt;
gt; gt; Why does my file go blank when saved as a .dbf
gt;
gt; --
gt;
gt; Dave Peterson
gt;

I don't use .dbf very often...

But excel uses a range named DataBase when it saves to the .dbf file.

Make sure your range named DataBase includes everything you want to keep.

You may want to delete that name (insert|name|define dialog) and reapply it to
your real data.

lelykg wrote:
gt;
gt; My version of excel is 2002 on xp pro
gt; The files contents always disappear without having to open the dbf with
gt; visual foxpro 9.0
gt; I would open the file saved as a .dbf in excel after saving and it would be
gt; blank in excel
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; In my simple testing in xl2003, my file didn't go blank.
gt; gt;
gt; gt; You may want to post more details on what you did--and what version of excel
gt; gt; you're using.
gt; gt;
gt; gt; (and what version of .dbf, too.)
gt; gt;
gt; gt; lelykg wrote:
gt; gt; gt;
gt; gt; gt; Why does my file go blank when saved as a .dbf
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

Thanks that Solved the problem

quot;Dave Petersonquot; wrote:

gt; I don't use .dbf very often...
gt;
gt; But excel uses a range named DataBase when it saves to the .dbf file.
gt;
gt; Make sure your range named DataBase includes everything you want to keep.
gt;
gt; You may want to delete that name (insert|name|define dialog) and reapply it to
gt; your real data.
gt;
gt; lelykg wrote:
gt; gt;
gt; gt; My version of excel is 2002 on xp pro
gt; gt; The files contents always disappear without having to open the dbf with
gt; gt; visual foxpro 9.0
gt; gt; I would open the file saved as a .dbf in excel after saving and it would be
gt; gt; blank in excel
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; In my simple testing in xl2003, my file didn't go blank.
gt; gt; gt;
gt; gt; gt; You may want to post more details on what you did--and what version of excel
gt; gt; gt; you're using.
gt; gt; gt;
gt; gt; gt; (and what version of .dbf, too.)
gt; gt; gt;
gt; gt; gt; lelykg wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; Why does my file go blank when saved as a .dbf
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;