Kalo syntax SQL saya rasa umum seperti :
insert into Xtab(column1, ....) values (value1, ....).
saya tidak tahu, sebenarnya proses/skenario yang bagaimana kamu/ronald
inginkan ?
Kalau cuma mau masukkan isi file CSV ke table, cara paling gampang adalah
anda buat saja datawindow kemudian preview datawindownya kemudian click ke
Rows->import (kalau anda memakai PB).
Kalau kamu memakai SQL Server 2000, anda bisa pakai DTS.
Kecuali ada teman lain yang punya cara yang lebih mudah.
Daniel F
> Betul,
> yg jadi pertanyaan dari pertama, Gimana sintaksnya , kalau
> saya punya 1 table sebut saja table nya
> tTransaksi(id,Kode,qty,desc,nilai)
> selain itu saya punya csv, sebut saja Sheet1(id,kode,nilai,des)
> Gimana caranya supaya Sheet1 masuk ke table tTransaksi ??
>
> Salam
> Ronald Irawan
> Pt. Sanghiang Perkasa
> Gd. Graha Kirana Lt.5
> Jl Yos Sudarso Kav.88
> Jakarta
>
>
>
> [EMAIL PROTECTED]
> Sent by: [email protected]
> 05/09/2006 09:43 AM
> Please respond to
> [email protected]
>
>
> To
> [email protected]
> cc
>
> Subject
> Re: [indopb]Imports Excel
>
>
>
>
>
>
> kalau isql sepertinya mesti pakai Syntax SQL.
>
>
>
> Daniel
>
>
>
>> Kalau dari ISQL gimana ya pa?
>>
>> Salam
>> Ronald Irawan
>> Pt. Sanghiang Perkasa
>> Gd. Graha Kirana Lt.5
>> Jl Yos Sudarso Kav.88
>> Jakarta
>>
>>
>>
>> [EMAIL PROTECTED]
>> Sent by: [email protected]
>> 05/09/2006 09:24 AM
>> Please respond to
>> [email protected]
>>
>>
>> To
>> [email protected]
>> cc
>>
>> Subject
>> Re: [indopb]
>>
>>
>>
>>
>>
>>
>>
>> cara paling gampang.
>>
>> pakai datawindow dengan function importfile.
>>
>> Daniel F.
>>
>>
>>> Dh,
>>> Kalau saya punya 1 table sebut saja table nya
>>> tTransaksi(id,Kode,qty,desc,nilai)
>>> selain itu saya punya csv, sebut saja Sheet1(id,kode,nilai,des)
>>> Gimana caranya supaya Sheet1 masuk ke table tTransaksi ??
>>>
>>> Salam
>>> Ronald Irawan
>>> Pt. Sanghiang Perkasa
>>> Gd. Graha Kirana Lt.5
>>> Jl Yos Sudarso Kav.88
>>> Jakarta
>>
>>
>> -----------------------------------------------
>> IndoPB - Indonesia PB User Group
>> An Indonesian PowerBuilder User Group's Event
>> 2nd PowerBuilder Update
>> Rumah Sakit Jantung Harapan Kita
>> 26/27 August 2006
>> To Register :
>> http://groups.yahoo.com/group/indopb/database?method=addRecord&tbl=4
>> Yahoo! Groups Links
>>
>>
>>
>>
>>
>>
>>
>>
>
>
> -----------------------------------------------
> IndoPB - Indonesia PB User Group
> An Indonesian PowerBuilder User Group's Event
> 2nd PowerBuilder Update
> Rumah Sakit Jantung Harapan Kita
> 26/27 August 2006
> To Register :
> http://groups.yahoo.com/group/indopb/database?method=addRecord&tbl=4
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
-----------------------------------------------
IndoPB - Indonesia PB User Group
An Indonesian PowerBuilder User Group's Event
2nd PowerBuilder Update
Rumah Sakit Jantung Harapan Kita
26/27 August 2006
To Register :
http://groups.yahoo.com/group/indopb/database?method=addRecord&tbl=4
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indopb/
<*> 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/
