ªð¦^¦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 : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD