IMPORT EXCEL FILE TO DBF

[Alex Gustow]

I've tried to export to Excel 2010 and it works OK.

"To export to"? Maybe it's little mistake of you, Marek? I think you wanted to type "to export from Excel"

Как говорил (кажется, товарищ Сталин): "Маленькая ошибка рождает большое недоверие"

Comrade Stalin (maybe I'm wrong) said: "A small error gives rise to a lack of confidence"

[mol]

No error, Now, I tried Export

[mol]

Now, I've tested reading from excel 2010 to dbf file and everything converts OK.

HMG is great!

Best regards, Marek

[Alex Gustow]

OK, Marek, I've tested today too on Excel 2010 - it works fine!

[swapan]

My sincere thanks to Marek for this coding.
And Alex thanks to you for the testing......its now VERIFIED & CERTIFIED BY ALEX!

Actually, my boss who wanted this kind of solution, has changed his mind and diverted me to a different task.
But this kind of routine was badly needed in our forum - as we've solutions for Dbf2Excel, and was lacking the reverse of it.....
Marek's routine will strenghten the package now with this Excel2Dbf facility.

Regards,

Swapan

[Alex Gustow]

VERIFIED & CERTIFIED BY ALEX!

Yessss!!! My world famous "Great Alex's Beta-Testing Corp. Inc. Ltd." (GABT) tested this routine and certified that IT WORKS on ALL known OSes and platforms!!! (including IMP PC [IBM PC XT - of course! but you must have at least one 360k floppy drive and at least one CGA display...], all MACs, iPhone, iPod, iCan, iCan't, Sony PlayStation-1 [2,3,4,5,6,7], PSP, XBox-360 [720, 1440 etc], Nintendo, ZX-Spectrum, Commodore, Atari etc... even on old PDP-11 mainframe [it stays - maybe till now - on my oooold - 1980's - work in one of laboratories of Russian Academy of Sciences]... we aren't sure that it works on abacus... we can't find abacus in museum... but maybe - we hope - it works too... and works FINE!!!)

[mol]

hahaha

[Rathinagiri]

I enjoyed your Professional touch Alex.

[dodogo]

Hi. I know it is off topic.. but..
How I can read name of sheet in excel file? (ODBC)
thx. dodogo

[RPC]

Try to change some code in my app:

Code: Select all

#define CRLF Chr( 13 ) + Chr( 10 )

#include "minigui.ch"

PROCEDURE MAIN()

Hi Mol
Thanks for this program to convert excel file to DBF file.
Can you provide the sample of Excel and DBF files referred to in the program.
Thanks
rpc