Excel and dBase IV databases...

How can I add characters to dBASE IV database in Excel (I'm using Office97)??

When I add characters, save that database and then open it those added characters have disappeared somehow.
I guess I have to somehow tell Excel a new database area so that Excel can save also those new characters? Or is it so?

Thanks in advance!
majalaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
vboukharConnect With a Mentor Commented:
If you try rewrite existing DBF file - Excel could miss new data - when you open DBF file in Excel look at named range Database. Change this named range to cover all your data and save as DBFIV
0
 
majalaAuthor Commented:
Edited text of question
0
 
majalaAuthor Commented:
Edited text of question
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
ZenMasterCommented:
Are the tables for DBIV linked into Excel?  If so, how so?  Or are you doing this programatically?
0
 
majalaAuthor Commented:
Tables aren't linked into Excel and I just wanna manually add characters to that dBase table.
0
 
antratCommented:
You would probaly have to have to save the file as a DB iv file. To do this select save as from the file menu then select the "Save as type" drop down dialog box , and scroll down to the "DB4 (Db IV ) (*,dbf) and select it.
Hope it works .
0
 
majalaAuthor Commented:
I do that already!
0
 
majalaAuthor Commented:
Yes, that really was the actual problem!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.