Harbour DBF to Excel Problem

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

Post Reply
User avatar
Rathinagiri
Posts: 5181
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 141 times
Been thanked: 131 times
Contact:

Harbour DBF to Excel Problem

Post by Rathinagiri » Sat Aug 09, 2008 9:33 am

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?
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
esgici
Posts: 4363
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 245 times
Been thanked: 91 times
Contact:

Post by esgici » Sat Aug 09, 2008 8:14 pm

Hi Rathinagiri
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?
I'm not sure, may be a 255 bytes limit. Do you haven't try dividing C500 field to two adjacent fields in C250 ?

Regards
Viva INTERNATIONAL HMG :D

User avatar
Rathinagiri
Posts: 5181
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 141 times
Been thanked: 131 times
Contact:

Post by Rathinagiri » Sun Aug 10, 2008 11:54 am

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.

Post Reply