ÈçºÎ°ÑaccessÊý¾Ý¿âµÄÄÚÈݵ¼³öµ½workÎĵµÖÐ?
ÈçºÎ°ÑaccessÊý¾Ý¿âµÄÄÚÈݵ¼³öµ½workÎĵµÖнøÐб༴òÓ¡?лл
ÈçºÎÓÃVB±àд³ÌÐòʵÏÖ°ÑaccessÊý¾Ý¿âµÄÄÚÈݵ¼³öµ½workÎĵµÖнøÐб༴òÓ¡? н¨µÄWordºÍÒÑÓеÄWordµÄ´úÂë¿Ï¶¨ÊDz»Ò»ÑùµÄ ÕâµãLZ»¹ÐèÒªÖ¸Ã÷ ÒýÓà ÈçºÎÓÃVB±àд³ÌÐòʵÏÖ°ÑaccessÊý¾Ý¿âµÄÄÚÈݵ¼³öµ½workÎĵµÖнøÐб༴òÓ¡? ´úÂëºÜ¶à,ËÑһϾÍÐÐ,²»¹ý1Â¥µÄÒѾºÜÏêϸÁË,¶¥Ò»Ï #2Â¥ ÒýÓà ´úÂëºÜ¶à,ËÑһϾÍÐÐ,²»¹ý1Â¥µÄÒѾºÜÏêϸÁË,¶¥Ò»Ï ÔÚACCESSÀïÃæ´æµÄ£¬¶¼ÊDZí¸ñµÄÐÎʽ£¬Ò»ÕÅÕÅÎïÀí±í¡£ÄãÒªµ¼³ö±à¼£¬µ¼³ö³ÉEXCELµÄ²»ÊǸüºÃ£¿£¿ Èç¹ûÓÃEXCELµÄµ¼³ö£¬¾Í¸ü¼Ó¼òµ¥ÁË¡£¼¸ÐдúÂë¾Í¸ã¶¨ Ö§³ÖһϠÒýÓà ÔÚACCESSÀïÃæ´æµÄ£¬¶¼ÊDZí¸ñµÄÐÎʽ£¬Ò»ÕÅÕÅÎïÀí±í¡£ÄãÒªµ¼³ö±à¼£¬µ¼³ö³ÉEXCELµÄ²»ÊǸüºÃ£¿£¿ Èç¹ûÓÃEXCELµÄµ¼³ö£¬¾Í¸ü¼Ó¼òµ¥ÁË¡£¼¸ÐдúÂë¾Í¸ã¶¨ ÒýÓà ´úÂëºÜ¶à,ËÑһϾÍÐÐ,²»¹ý1Â¥µÄÒѾºÜÏêϸÁË,¶¥Ò»Ï ÊÇ2Â¥µÄ,lzµ÷ÊÔµÄÕ¦ÑùÁË µ½wordÖÐÂ¼ÖÆºê£¬È»ºóÔÚVBÖÐÓÃVBAÖ´ÐоÍÐÐÁË¡£ Ö§³Ö¶þÂ¥ 2Â¥µÄ´úÂëÎÒ·ÅÈëVBÖÐÔËÐе½ Set Appword = New Word.Application ÌáÐѱ༴íÎó,ÎÞЧÍⲿ¹ý³Ì,ʲôÔÒò?
Ïà¹ØÎÊ´ð£º
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý" ²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!! ´ó¼Ò¶¼ ......
accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í ¶ÁÈ¡Êý¾Ý È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡ Ò»´ÎÈ«²¿¶ÁÍê ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺 £¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£® µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
Çë¸÷λָµãÏ£º³ÌÐò´úÂëÈçÏÂmingchen = "C:\Îļþ·¾¶\" cat = New ADOX.Catalog cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & min ......