Harbour DBF to Excel Problem

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

Post Reply
User avatar
Rathinagiri
Posts: 5172
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 136 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: 4345
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 229 times
Been thanked: 80 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: 5172
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 136 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