excel vba ¬d¸ß Sqlite¸ê®Æ®w(³]©w»P»yªk)½d¨Ò
- ©«¤l
- 361
- ¥DÃD
- 57
- ºëµØ
- 0
- ¿n¤À
- 426
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2003,2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2022-12-8
|
excel vba ¬d¸ß Sqlite¸ê®Æ®w(³]©w»P»yªk)½d¨Ò
¥»©«³Ì«á¥Ñ joey0415 ©ó 2013-7-31 20:16 ½s¿è
¦Û¤v¸Õ¤F«Ü¤[¡A²×©ó¦¨¥\¤F¡Aºô¸ô¤W¥Hvba¾Þ§@sqliteªº¤å³¹«D±`¤Ö¡A©Ò¥HµoÓ¤å¨Ó¬ö¿ý¤@¤U
¤£¯à¶Çªþ¥ó¡Aªþ¤Wdorpbox³sµ²¤U¸ü
sqlite odbc drivern¸Ë
http://www.ch-werner.de/sqliteodbc/
ªþ¤W½m²ß¸ê®Æ®w»Pexcel vba ÀÉ
https://dl.dropboxusercontent.com/u/40393708/sqlite/sqlite3.zip- Sub select¿é¥X¦Üsheet1¤¤()
- Dim cn, rs, f
-
- Set cn = CreateObject("adodb.connection")
- '¶}±Òsqlite«ü©w¸ê®Æ®w¡A¸ô®|»PÀɮצWºÙn¹ï
- cn.Open ("Driver={SQLite3 ODBC Driver};database=E:\joey.sqlite")
- '¼g¥XSQL¬d¸ß»yªk
- Set rs = cn.Execute("SELECT * FROM home ")
- Sheet1.Cells.Delete
- For f = 0 To rs.fields.Count - 1
- Sheet1.Cells(1, f + 1).Value = rs.fields(f).Name
- Next
- Sheet1.Cells(2, 1).CopyFromRecordset (rs)
- cn.Close
- End Sub
½Æ»s¥N½X- Sub insert()
- Dim x
- Dim sql_command As String
- Dim connection_string As String
-
- Set x = CreateObject("adodb.recordset")
- sql_command = "insert into home(name, age) values('mary','50') "
- connection_string = ("Driver={SQLite3 ODBC Driver};database=E:\joey.sqlite")
- x.Open sql_command, connection_string
- Set x = Nothing
-
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 361
- ¥DÃD
- 57
- ºëµØ
- 0
- ¿n¤À
- 426
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2003,2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2022-12-8
|
¦^´_ 2# koshi0413
©Ò¦³ÓªÑªÑ»ù¸ê®Æ©ñ¶i³æ¤@ÀɮסA¨Ò¦pstock.sqlite¤¤¡A¦A³z¹Lselect ¿ï¥X§AnªºªÑ²¼¸ê®Æ¤~¹ï¡A¦]¬°©ñ¶i¦P¤@Ó¸ê®Æ¡A¤~¥i¥H¿ï©Ò¦³«ü©w°Ï¶¡ªºªÑ²¼»PªÑ»ùµ¥¡K
¡A³o¼Ë¤£¥Î´X¬í¡A³z¹Lµ{selectªº»yªk¡AÁÙ¥i¥H«ü©w°Ï¶¡ÂàÀɳæ¶g©Î³æ¤ë©Ò¦³ªÑ²¼¶g©Î¤ë¸ê®Æ¡A¤@©w¤£¥Î30¬í¡A§Úªº¸ê®Æ®w¤»¦~¤é¶g¤ë©Ò¦³ªÑ²¼»P¶°«O¡AÀɮפ~800mb
¨S¦³¤°»ò°ÝÃD |
|
|
|
|
|
|
- ©«¤l
- 361
- ¥DÃD
- 57
- ºëµØ
- 0
- ¿n¤À
- 426
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2003,2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2022-12-8
|
¦^´_ 4# koshi0413
§A¬Ý¹Ï´Nª¾¹D¤F
120mb«Ü¤Ö¡Asqlite®e¶q³Ì¤j¬O2T¡A«Ü°÷¥Î
¸ê®Æ§ì±o¨ì¡A·|¥ÎSQL »yªk¥i¥H¸Ñªk«Ü¦h°ÝÃD¡A¥¦ªº¹Bºâ¤ñVBA°}¦Cµ¥³£ÁÙ§Ö¤W³\¦h
|
|
|
|
|
|
|
- ©«¤l
- 361
- ¥DÃD
- 57
- ºëµØ
- 0
- ¿n¤À
- 426
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2003,2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2022-12-8
|
¦^´_ 5# PKKO
±z¦n¡I
¤@¡BÀ³¸Ó¤@¼Ë¤~¹ï¡A¸ê®Æ³£¬O¶i§ì¨Ó´N¥ý³B²z¦n(¸ê®Æ®æ¦¡)
¤G¡BACCESS³Ì¤j2G, sqlite 2T¡A³s½u¤H¼Æ§Ú¨S¸Õ¹L¡A³t«×¤@¼Ë§Ö
¤T¡B¥¦¬O³æ¤@ÀɮסAª½±µ½Æ»s¶K¤W§Y¥i¡A®t²§³Æ¥÷¦n±ø¨S¦³ |
|
|
|
|
|
|
- ©«¤l
- 361
- ¥DÃD
- 57
- ºëµØ
- 0
- ¿n¤À
- 426
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2003,2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2022-12-8
|
¦^´_ 10# c_c_lai
¿à¤j±z¦n¡I
¬Ý§Aªº¨t²Î¬O32ÁÙ¬O64¡A¿ï¾Ü¥¿½Tª½±µ¸Ë´N¥i¥H¥Î¤F
¥¦¥u¬OÅX°Êµ{¦¡ |
|
|
|
|
|
|
- ©«¤l
- 361
- ¥DÃD
- 57
- ºëµØ
- 0
- ¿n¤À
- 426
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2003,2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2022-12-8
|
¦^´_ 13# c_c_lai
èè¸Ëªº¥u¬OÅX°Ê
³q±`³£¥Îfirefox ªº¥~±¾ sqlite manager (¤£¥Î¿ú)¨Ó·s«Ø
|
|
|
|
|
|
|