Path: csiph.com!usenet.pasdenom.info!news.albasani.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Er!k \\/!$$Er" Newsgroups: comp.lang.clipper.visual-objects Subject: Re: Copy complete dbf to sql Date: Fri, 4 May 2012 13:42:49 +0200 Lines: 39 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Trace: individual.net SeaEwomTXj8ThpCwvu/qww7Y5LiapDYCnoOsYinNgE3ES1HhpVVO24gY4gC2l0me4n Cancel-Lock: sha1:erHNfl+S/Gv8G6LeYbVYVKev9SU= In-Reply-To: X-Priority: 3 X-MSMail-Priority: Normal Importance: Normal X-Newsreader: Microsoft Windows Live Mail 15.4.3555.308 X-MimeOLE: Produced By Microsoft MimeOLE V15.4.3555.308 Xref: csiph.com comp.lang.clipper.visual-objects:3409 Hi Dirk, Write the values to CSV and do a BULK INSERT on the Sql database. or have a look here: http://stackoverflow.com/questions/883917/import-dbf-files-into-sql-server hth Erik "Dirk (Belgium)" schreef in bericht news:jo04v3$kuo$1@dont-email.me... Hi all, On a daily base, I have to copy all records from dbf to sql. This is done in a task which runs during the night, but it takes already 62 minutes (too long). On this moment, I use the standard VO SQL classes. First I do a prepare statement INSERT INTO (field1,field2,...) VALUES (?,?,...) After this, for each record of the dbf file, I do the SQLStatement{}:Execute() method with an array of the values. So, this process takes to long. My question: Does someone know how to speed up this process ???? Thanx for any advice, Dirk (Belgium) --