Harbour DBF to Excel Problem

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

Post Reply
User avatar
Rathinagiri
Posts: 5477
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Harbour DBF to Excel Problem

Post by Rathinagiri »

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: 4543
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Contact:

Re: Harbour DBF to Excel Problem

Post by esgici »

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: 5477
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

Post by Rathinagiri »

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