I have a dbf created using HMG. In which I have a field of characters having width of 500. If I import this dbf into Excel/Openoffice it is broken. When I shrink into 200 characters, It is imported correctly.
Is there any limitation in this regard?
Harbour DBF to Excel Problem
Moderator: Rathinagiri
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Harbour DBF to Excel Problem
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
- esgici
- Posts: 4543
- Joined: Wed Jul 30, 2008 9:17 pm
- DBs Used: DBF
- Location: iskenderun / Turkiye
- Contact:
Re: Harbour DBF to Excel Problem
Hi Rathinagiri
Regards
I'm not sure, may be a 255 bytes limit. Do you haven't try dividing C500 field to two adjacent fields in C250 ?rathinagiri wrote:I have a dbf created using HMG. In which I have a field of characters having width of 500. If I import this dbf into Excel/Openoffice it is broken. When I shrink into 200 characters, It is imported correctly.
Is there any limitation in this regard?
Regards
Viva INTERNATIONAL HMG ![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: Harbour DBF to Excel Problem
Yes. I had done like that and solved the problem. Thanks Esgici.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.