Page 2 of 4
Re: IMPORT EXCEL FILE TO DBF
Posted: Wed Feb 10, 2010 6:31 pm
by Alex Gustow
mol wrote: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"
Re: IMPORT EXCEL FILE TO DBF
Posted: Wed Feb 10, 2010 7:34 pm
by mol
No error, Now, I tried Export
Re: IMPORT EXCEL FILE TO DBF
Posted: Wed Feb 10, 2010 7:41 pm
by mol
Now, I've tested reading from excel 2010 to dbf file and everything converts OK.
HMG is great!
Best regards, Marek
Re: IMPORT EXCEL FILE TO DBF
Posted: Thu Feb 11, 2010 4:50 pm
by Alex Gustow
OK, Marek, I've tested today too on Excel 2010 - it works fine!
Re: IMPORT EXCEL FILE TO DBF
Posted: Thu Feb 11, 2010 5:46 pm
by 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
Re: IMPORT EXCEL FILE TO DBF
Posted: Thu Feb 11, 2010 6:26 pm
by Alex Gustow
swapan wrote: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!!!)
Re: IMPORT EXCEL FILE TO DBF
Posted: Thu Feb 11, 2010 8:17 pm
by mol
hahaha
Re: IMPORT EXCEL FILE TO DBF
Posted: Fri Feb 12, 2010 12:48 am
by Rathinagiri
I enjoyed your Professional touch Alex.
Re: IMPORT EXCEL FILE TO DBF
Posted: Sat Feb 13, 2010 2:34 pm
by dodogo
Hi. I know it is off topic.. but..
How I can read name of sheet in excel file? (ODBC)
thx. dodogo
Re: IMPORT EXCEL FILE TO DBF
Posted: Wed Apr 17, 2024 6:03 pm
by RPC
mol wrote: ↑Wed Feb 10, 2010 7:59 am
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