1. Pilih kelompok tab Import
2. Piih Text File
3. Pilih Radio Button "Append a copy of records to table" , isi tale tujuan
4.Isi File Name dengan nama file csv/text
5. Pilih command button OK
6. Piih delimited
7. klik next
8.Pilih Comma
9. klik Next
10. isi table tujuan di "import to"
11. klik Finish
12. klik Close
'==== ini menngunakan menu
dengan VBA mungkin ada yang menambahkan ? silakan
'
--- In belajar-access@yahoogroups.com, "Access Wizards" <accesswizards@...> wrote:
>
>
> No,Nama,Alamat,Kota
>
>
> 1,Andy,Jl Jaksa 123,Jakarta
>
>
> 2,Budi,Jl Ambarawa,Jogjakarta
>
>
>
> Mohon bantuan rekan bagaimana cara import data .csv ke dalam table access
> jika datanya di pisahkan dalam bentuk "," bukan dalam bentuk kolom/field
>
> Atas perhatiannya kami ucapkan terima kasih.
>
>
>
>
>
> Best Regards,
>
> AccessWizards
>
------------------------------------
SPAM IS PROHIBITEDYahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/belajar-access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/belajar-access/join
(Yahoo! ID required)
<*> To change settings via email:
belajar-access-digest@yahoogroups.com
belajar-access-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
belajar-access-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
No comments:
Post a Comment