silahkan download di folder hammet pada millist ini mengenai men-Zip 
files dalam folder.



--- In [email protected], Febriyanno Suryana 
<[EMAIL PROTECTED]> wrote:
>
> masalah coding DBF-->SQL nya dah kelar.. makasih semuanya..
>   nambah pertanyaan lg nihh..
>   Gimana coding kolo kita mo zip file dalam suatu folder mis : 
dari folder A ke folder B dg vb ? dan secara otomatis isi folder A 
yg telah di zip td pindah ke folder B
> 
> destroyer_maniac <[EMAIL PROTECTED]> wrote:
>   ini rumus SQL untuk mengimport data DBF ke SQL SERVER.
> 
> Rumus Pertama :
> 
> "insert into [NmTabel](Field1,NmField2,NmField3) SELECT
> Field1,NmField2,NmField3 FROM OpenDataSource
> ('Microsoft.Jet.OLEDB.4.0','Data Source=G:\rifa;User
> ID=Admin;Password=;Extended properties=DBASE IV')...NamaFileDBF"
> 
> Rumus KE 2(Jika Susunan Field Tabel yang di SQLSERVER telah sama
> dengan Susunan Field yang ada di DBF):
> 
> "insert into [NmTabel] SELECT * FROM OpenDataSource
> ('Microsoft.Jet.OLEDB.4.0','Data Source=G:\rifa;User
> ID=Admin;Password=;Extended properties=DBASE IV')...NamaFileDBF"
> 
> 
> Praktek untuk lebih jelas Ke VB NYa :
> 
> 
> Dim cn As New ADODB.Connection
> 
> Private Sub Import()
> 
> If cn.State = 1 Then cn.Close
> cn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User
> ID=sa;pwd=rm;Initial Catalog=SQL;Data Source=SERVER"
> 
> cn.CursorLocation = adUseClient
> 
> cn.Execute "insert into [NamaTabel] SELECT * FROM OpenDataSource
> ('Microsoft.Jet.OLEDB.4.0','Data Source=G:\rifa;User
> ID=Admin;Password=;Extended properties=DBASE IV')...Penjualan"
> 
> End Sub
> 
> 
> 
> 
> 
> 
> Wahana Programmer Groups Links
> 
> 
> 
> 
> 
> 
>     
> ---------------------------------
>   YAHOO! GROUPS LINKS 
> 
>     
>     Visit your group "Programmer-VB" on the web.
>     
>     To unsubscribe from this group, send an email to:
>  [EMAIL PROTECTED]
>     
>     Your use of Yahoo! Groups is subject to the Yahoo! Terms of 
Service. 
> 
>     
> ---------------------------------
>   
> 
> 
> 
>               
> ---------------------------------
> Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 
30+ countries) for 2ยข/min or less.
>







Wahana Programmer Groups Links

<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
    http://wahanaprogrammer.net

<*> Untuk menghubungi owner milis ini, kirim email ke:
    [EMAIL PROTECTED]

<*> Konsultasi pemrogramman bisa chat disini:
    Yahoo! Messenger: wahanaprogrammer
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/Programmer-VB/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 



Kirim email ke