3. Pertemuan III Impor Data dengan Excel.pptx

Pertemuan III Impor Data dengan Excel

1. IMPOR DATA DENGAN EXCEL

2. IMPOR DATA Merubah data ke bentuk tabel excel (. xlsx ) Menu : Get External Data New Query

3. PERSIAPAN Buat Folder TABK Excel Buat folder dalam TABK Excel 1_Data 2_Impor 3_Manajemen 4_Analisis Unduh data dari google drive dan simpan dalam folder 1_Data https://drive.google.com/file/d/1O7BHCNaD95Sv_a21YjG6JWrRnVd-0e1n/view?usp=sharing

4. Get External Data Get External data From Access -> CustRec.accdb -> GED_Custrec Get External data From Web -> Disbursement.HTML -> GED_Disbursement Get External Data From Text Text Delimited ( Files . csv )-> Sales.csv -> GED_Sales Text Delimited ( Files . txt ) -> Suppliers.txt -> GED_Suppliers Text Fixed Width ( Files.prn ) -> Report.prn -> GED_Report Get External data From Impor XML -> ProdClass.xml -> GED_ProdClass Get External data From File dBase -> PRODUCT1.DBF & PRODUCT2.DBF -> GED_Product

5. Get New Query New Query – From File – CSV -> Sales .csv -> NQ_Sales New Query – From File – XML -> ProdClass.xml -> NQ_ProdClass New Query – From File – Text -> Supplier.txt -> NQ_Suppliers New Query – From Database - Access -> CustRec.accdb -> NQ_CustRec New Query – From Other sources – Web -> Disbursement.html -> NQ_Disbursement