Ôõô½«excel2003Êý¾ÝÓÐÑ¡ÔñµÄµ¼Èëµ½ sqlserver!!!
2002Äê5ÔÂÖ°¹¤»¨Ãû²á
ÐòºÅ ÐÕÃû ÐÔ±ð Ãñ×å ¹¤×Ê
1 ÕÅÈý ÄÐ ºº 800.00
2 ÀîËÄ ÄÐ »Ø 1200.00
3 ÕÅÜ¿ Å® ºº 852.00
4 ºÎÌìÈÙ ÄÐ Âú 962.00
ÀýÈçÉÏÃæÎÒÖ»ÒªÊý¾Ý£¬¶ø²»Òª±êÌâºÍÁÐÃû
SQL code:
SELECT * into newtable from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0','Data Source="d:\book1.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[a1$]
ÉÏÃæÕâ¸ö²»ÐÐ
ллÁË£¬ÎÒÖ»ÓÐÕâô¶à·ÖÁË
1.°ÑÊý¾ÝÈ«²¿µ¼Èëµ½Ò»¸öÁÙʱ±í.
2.¸ù¾ÝÄãµÄÌõ¼þÑ¡ÔñÄãÐèÒªµÄÊý¾Ý.
½¨Á¢Ò»¸ö±ítable£¨Ïàͬ½á¹¹µÄ±í£©
½«ÒÔÉÏÓï¾äµ¼Èë±ítable
SQL code:
insert into table
SELECT * from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0','Data Source="d:\book1.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[a1$]
ÒªÊÇ»¹²»ºÃʹµÄ»°£»¿ÉÒÔÊÔ×ÅÓÃSSISÀ´¡£¡£
Ö±½ÓÓÃÊý¾Ýµ¼È빦ÄÜ£¬ÀïÃæ¿ÉÒÔÉèÖÃÌõ¼þ
ÎÒÏëÓóÌÐòʵÏÖ£¬¿´À´ÊÇû°ì·¨ÁË£¬½áÌû
Ïà¹ØÎÊ´ð£º
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
±êÌâ: Á¬½Óµ½·þÎñÆ÷
------------------------------
ÎÞ·¨Á¬½Óµ½ LIJINING-PC¡£
------------------------------
ÆäËûÐÅÏ¢:
Òѳɹ¦Óë·þÎñÆ÷½¨Á¢Á¬½Ó£¬µ«ÊÇÔڵǼ¹ý³ÌÖз¢Éú´íÎó¡£ (provider: ¹²ÏíÄÚ´æÌṩ³ÌÐò, ......
ÓÃNetBeans×Ô¶¯´´½¨ÁËÒ»¸öÊý¾Ý¿âÓ¦ÓóÌÐò£¨Ò»¸ö×ÀÃæÓ¦ÓóÌÐò£©£¬ÊµÏÖ»ù±¾µÄ¶Ô±íµÄÌí¼Ó¡¢É¾³ý¡¢Ð޸ġ¢Ë¢Ð£¬ÀïÃæÉú³ÉÁËÈý¸öÎļþ£¬Ò»¸öÊÇGUIÏÔʾ£¬Ò»¸öÊÇÈë¿ÚÎļþ£¨ launch(CarsApp3App.class, args)£©»¹ÓÐÒ»¸öÎļþ£¬Î ......
ÒÔÏ´úÂëÊÇÌí¼ÓÊý¾Ý°´Å¥µÄ´úÂ룬Ïë°Ñtestid£¬ºÍtestnameÁ½¸ötxt´«µÝµ½Êý¾Ý¿âÖÐ
Êý¾Ý¿âÁ¬½Ó¿Ï¶¨Ã»ÎÊÌâ
¾ÍÊǺìÉ«²¿·ÖÀϱ¨´í
²»ÖªµÀΪʲô-£¬-
Çë¸÷λ¸ßÈË°ïæ¿´¿´£¡
лл£¡
Java code:
private void new ......
3GµÄVS2008£¬ºÃÏñĬÈÏ°²×°µÄʱºò´øÁ˺ܶණÎ÷¡£±ÈÈçsqlserver2005£¬µ«ÊÇÎÒ²»ÖªµÀÕâ¸ö¸½´øµÄsqlserver2005ºÍsqlserver2005ÓÐʲô¹Øϵ£¿
Ò»¸öÊÇÔËÐл·¾³£¬Ò»¸öÊdzÌÐò£¿
Èç¹û×°ÁËvs2008£¬ÔÙ×°sqlserver2005ºÃÏñÓÖ ......