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

[µo°Ý] excel ¾ãÄæ¶×¤J sql ¤¤¤å¶Ã½X ¦p¦ó¥[N

[µo°Ý] excel ¾ãÄæ¶×¤J sql ¤¤¤å¶Ã½X ¦p¦ó¥[N

¦¹»yªk¬O±N¾ãÄæ¸ê®Æ¶×¤J¸êsqlserver¸ê®Æªí,
³æµ§¶×¤J(¥i¥¿½T¼g¤J¤¤¤å)
  sql= "insert into «È¤á¸ê®Æ (©m¦W)   values(N'¤¤¤å)"


¦hµ§¶×¤J(¼g¤J¤¤¤å¬°¶Ã½X) ¸Ó¦p¦ó¥[¤J N©Î¬O¥i¥Îcstr©O?
'sql = " INSERT INTO «È¤á¸ê®Æ(©m¦W) SELECT " ©m¦W " FROM «È¤á¸ê®Æ"

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD