ÀÚÁÖ Áú¹®µÇ´Â »çÇ× ¹× ´äº¯
1. óÀ½¿¡ ±³ÀÎÀÚ·á ¹× Çå±ÝÀڷḦ ±âÁ¸ database¹× spreadsheet·ÎºÎÅÍ importÇÒ¼ö ÀÖ½À´Ï´Ù.
¸ÕÀú ExcelÀ» °¡µ¿ÇÏ¿© \ctm\data\member.dbf¸¦ data-¿ÜºÎdata°¡Á®¿À±â¸¦ ÇÏ¸é ±³ÀÎÁ¤º¸°¡ spreadsheet»ó¿¡ ³ªÅ¸³³´Ï´Ù(ÆÄÀÏÁ¾·ù´Â visual foxpro table). ¿©·¯ºÐÀÌ °¡Áö°í °è½Å Excel ÆÄÀÏÀ» ÀÐ¾î¼ column´ÜÀ§·Î matchingµÇ´Â °÷¿¡ cut and pasteÇϽʽÿä. ÁÖÀÇÇϽÇÁ¡Àº Áö¿ª¹øÈ¿Í ÀüȹøÈ£µîÀº ¼ýÀÚ Çü½ÄÀ¸·Î µÇ¾î ÀÖ¾î¾ß ÇÕ´Ï´Ù. ¾î¶²ÀÚ·á°¡ ¼ýÀÚÀÌ°í ¾î¶²ÀÚ·á°¡ ¹®ÀÚÀÎÁö´Â Database Table Field DescriptionÀ» Âü°íÇϽʽÿä. ±³ÀιøÈ£´Â 4ÀÚ¸® ¶Ç´Â 5ÀÚ¸®¸¦ À¯ÁöÇÏ¿© Áֽʽÿä. ¿¹·Î 23¹øÀº 0023À¸·Î ÇÏ¿© Áֽʽÿä. ÀÌ·¸°Ô ÀÛ¼ºµÈ spreadsheetÀ» save ÇÑ´ÙÀ½
Çå±ÝÇÁ·Î±×¶÷À» °¡µ¿ÇÏ¿© memberÀÇ browse allÀ» ½ÇÇàÇϸé table menu°¡ Ãß°¡·Î ³ªÅ¸³ª°í append record¸¦ ¼±ÅÃÇÕ´Ï´Ù. type¿¡ ExcelÀ» ¼±ÅÃÇϽðí from¿¡ À§¿¡¼ saveÇÑ ÆÄÀÏÀ̸§À» ÁÖ½Ã¸é µË´Ï´Ù. ±×¸®°í OK¸¦ ´©¸£½Ê½Ã¿ä.
2. Database ±¸Á¶
Database Table Field Description
¡¡