?
Solved

Excel and dBase IV databases...

Posted on 1999-01-20
8
Medium Priority
?
315 Views
Last Modified: 2013-11-24
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!
0
Comment
Question by:majala
8 Comments
 

Author Comment

by:majala
ID: 1615812
Edited text of question
0
 

Author Comment

by:majala
ID: 1615813
Edited text of question
0
 
LVL 1

Expert Comment

by:ZenMaster
ID: 1615814
Are the tables for DBIV linked into Excel?  If so, how so?  Or are you doing this programatically?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:majala
ID: 1615815
Tables aren't linked into Excel and I just wanna manually add characters to that dBase table.
0
 
LVL 9

Expert Comment

by:antrat
ID: 1615816
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
 

Author Comment

by:majala
ID: 1615817
I do that already!
0
 
LVL 5

Accepted Solution

by:
vboukhar earned 200 total points
ID: 1615818
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
 

Author Comment

by:majala
ID: 1615819
Yes, that really was the actual problem!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA).  The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to s…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question