ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] 2013¤É¯Å2016 µ{¦¡½X­×¥¿

[µo°Ý] 2013¤É¯Å2016 µ{¦¡½X­×¥¿

¥»©«³Ì«á¥Ñ starry1314 ©ó 2015-10-26 15:36 ½s¿è

¦]¤É¯Åª©¥»±qEXCEL±N¸ê®Æ¾É¤J¨ìaccess ¥i¥¿±`¨Ï¥Î
office 2013
cnn.Open "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=" & myPath '³s±µ¼Æ¾Ú®w

office 2016
cnn.Open "Provider=Microsoft.Ace.OLEDB.16.0;Data Source=" & myPath '³s±µ¼Æ¾Ú®w
¥H¤W­×§ï«á¥i¦A2016¥¿±`¨Ï¥Î

¥H¤UµLªk¥¿±`¨Ï¥Î
office 2013
SQL = "update " & myTable & " a,[Excel 12.0;imex=0;Database=" & ActiveWorkbook.FullName & "]
office 2016
SQL = "update " & myTable & " a,[Excel 16.0;imex=0;Database=" & ActiveWorkbook.FullName & "] µLªk¨Ï¥Î

        ÀR«ä¦Û¦b : ¯àµ½¥Î®É¶¡ªº¤H¡A¥²¯à´x´¤¦Û¤v§V¤Oªº¤è¦V¡C
ªð¦^¦Cªí ¤W¤@¥DÃD