editing dBase files
-
Hi, a collegue works with a program that uses dBase files to store it's data. He's looking for a tool to merge two of these. Excel doesn't do the job (as soon as it gets interesting, the app tells him "invalid format" on an excel-saved file) Any ideas? I know dBase only from the east german clone ( anyone doing redabas lately ;) ), I don't even know what happened to them... do they still exist?
So many people long for eternity that don't know what to do on a rainy sunday afternoon.
[sighist] | [Agile Programming] [doxygen]
If you look for evil in me you will find it whether it's there or not. -
Hi, a collegue works with a program that uses dBase files to store it's data. He's looking for a tool to merge two of these. Excel doesn't do the job (as soon as it gets interesting, the app tells him "invalid format" on an excel-saved file) Any ideas? I know dBase only from the east german clone ( anyone doing redabas lately ;) ), I don't even know what happened to them... do they still exist?
So many people long for eternity that don't know what to do on a rainy sunday afternoon.
[sighist] | [Agile Programming] [doxygen]
If you look for evil in me you will find it whether it's there or not.Does this sound like the problem? Excel Fields May Save Incorrectly in dBASE Formats (.*dbf) http://support.microsoft.com/default.aspx?scid=kb;en-us;214131[^] v1.1 post OR Error Message: Invalid Data Format http://support.microsoft.com/default.aspx?scid=kb;en-us;211596[^] Later,
JoeSox
www.joeswammi.com Untitled[^] | GWB CP Profile[^] -
Does this sound like the problem? Excel Fields May Save Incorrectly in dBASE Formats (.*dbf) http://support.microsoft.com/default.aspx?scid=kb;en-us;214131[^] v1.1 post OR Error Message: Invalid Data Format http://support.microsoft.com/default.aspx?scid=kb;en-us;211596[^] Later,
JoeSox
www.joeswammi.com Untitled[^] | GWB CP Profile[^] -
Hi, a collegue works with a program that uses dBase files to store it's data. He's looking for a tool to merge two of these. Excel doesn't do the job (as soon as it gets interesting, the app tells him "invalid format" on an excel-saved file) Any ideas? I know dBase only from the east german clone ( anyone doing redabas lately ;) ), I don't even know what happened to them... do they still exist?
So many people long for eternity that don't know what to do on a rainy sunday afternoon.
[sighist] | [Agile Programming] [doxygen]
If you look for evil in me you will find it whether it's there or not.Hi Excel has limitation of 65000 rows and for this reason it is not best tool for this job. You can try with Access. There is an ODBC Driver for dBase, or you can also use Visual FoxPro driver. Other possibility is purchase of Visual FoxPro - it can read dBase files as native format. Beware of 2 GB Limitation of this format. Sincerely Marek
-
Hi Excel has limitation of 65000 rows and for this reason it is not best tool for this job. You can try with Access. There is an ODBC Driver for dBase, or you can also use Visual FoxPro driver. Other possibility is purchase of Visual FoxPro - it can read dBase files as native format. Beware of 2 GB Limitation of this format. Sincerely Marek
MarkV wrote: Excel has limitation of 65000 rows and for this reason it is not best tool for this job. You can try with Access. FYI, Access has that same limitation unless you are using ODBC through it. Jeremy Falcon Imputek
-
Hi, a collegue works with a program that uses dBase files to store it's data. He's looking for a tool to merge two of these. Excel doesn't do the job (as soon as it gets interesting, the app tells him "invalid format" on an excel-saved file) Any ideas? I know dBase only from the east german clone ( anyone doing redabas lately ;) ), I don't even know what happened to them... do they still exist?
So many people long for eternity that don't know what to do on a rainy sunday afternoon.
[sighist] | [Agile Programming] [doxygen]
If you look for evil in me you will find it whether it's there or not.Have you tried Visual FoxPro? -- Chatai. Yana ra Yakana ro futisha ta?
-
Have you tried Visual FoxPro? -- Chatai. Yana ra Yakana ro futisha ta?
Don't have it (I guess - unless it's included with Office 2000 Pro, or VC6 Pro). I guess I'll try the ODBC provider for dBase - if I find it ;) My collegue just found a weay to convince Excel to do what he wants, so it's not that urgent anymore. Thanks! Peter
So many people long for eternity that don't know what to do on a rainy sunday afternoon.
[sighist] | [Agile Programming] [doxygen]
If you look for evil in me you will find it whether it's there or not. -
Don't have it (I guess - unless it's included with Office 2000 Pro, or VC6 Pro). I guess I'll try the ODBC provider for dBase - if I find it ;) My collegue just found a weay to convince Excel to do what he wants, so it's not that urgent anymore. Thanks! Peter
So many people long for eternity that don't know what to do on a rainy sunday afternoon.
[sighist] | [Agile Programming] [doxygen]
If you look for evil in me you will find it whether it's there or not.I think it's in the Visual Studio package. I'm not 100% positive. peterchen wrote: My collegue just found a weay to convince Excel to do what he wants, so it's not that urgent anymore. Isn't that always the case with Excel? You have to convince it. Sometimes even by force. -- Chatai. Yana ra Yakana ro futisha ta?