import xcell ka ms.acces make macro Ngalakukeun import file xcell ka ms.akses memang henteu hese. Urang tinggal pilih file--import--teangan file nu rek diimport. Geus kitumah tinggal jawab wae pertanyaan2 ms.acces. Cari ieu lumayan rada makan waktu. Tapi urang boga cara nu leuwih terah. Make makro. Kieu carana;
1. asup ka tabulasi makro 2. di kolom ACTION pilih transferSpreadsheet 3. Geus kitumah tinggal eusi baris baris patarosan diteohna; #transfer type=import #spreadsheet type=microsoft xcell 5-7 #table name=ngaran tabel di ms.akses. bisa make tabel anyar atawa tabel nu geus aya. Mun dieusi make ngaran tabel nu geus aya hasil import bakal ditambahkeun (append) ka tabel nu geus aya. #field name= eusikeun ngaran file nu rek diimport plus direktorina. Misalna kieu c:\kerja\cb\cashbook.xls #has field names; jawab yes. Patarosan eta hartina nama tabel maneh aya judul kolomna? Tangtu aya. Mun euweuh judul kolomna (field name) jawab No #Range; kosongkeun bae nu ieumah. teu ngaruh. #beres. simpen file terus jalankeun makrona. ------------------------ Yahoo! Groups Sponsor --------------------~--> DonorsChoose.org helps at-risk students succeed. Fund a student project today! http://us.click.yahoo.com/t7dfYD/FpQLAA/E2hLAA/0EHolB/TM --------------------------------------------------------------------~-> Komunitas Urang Sunda --> http://www.Urang-Sunda.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/urangsunda/ <*> 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/
