rumus SQL nya :

"Insert Into [NamaTableYangAdaDiSQLServer] select * from openrowset
('Microsoft.Jet.OLEDB.4.0','path\NMDatabase.mdb';'admin';'Password', 
NMTable)"

ATAU :

"Insert Into [NamaTableYangAdaDiSQLServer](Field1,field2,field3) 
select Field1,field2,field3 from openrowset
('Microsoft.Jet.OLEDB.4.0','path\NMDatabase.mdb';'admin';'Password', 
NMTable)"

NB :

User ID='admin' (Default)
Password='' (Default)


--- In [email protected], "win_ky" <[EMAIL PROTECTED]> wrote:
>
> halo smua para master programmer
> saya mau nanya,gimana cara mengimport program 
> aplikasi(vb&access) ke dalam program aplikasi(vb&sql 
> server)? trus,,ada yang punya contoh program aplikasi 
> sederhana penjualan/peminjaman berbasis vb&sql ga?? buat 
> referensi saya, maklum baru belajar..klo ada kirimin ya??
> thanks be4 buat siapa aja yang mau bantuin,,
> lam kenal
> winky
> ===========================================================
> Ikuti Lomba Puisi Online Jawa Timur, dapatkan hadiah menarik 
setiap bulannya 
> dan hadiah total senilai 60 juta rupiah
> hanya di 
> http://www.plasa.com
> (Khusus Jawa Timur)
> ===========================================================
>







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