ExcelHome̳

 һ
 ע

QQ¼

ֻһٿʼ

ݵ¼

EH-רҵְܳվ գȤζ Excel-Excel,ϵͳ Чһ㶨
HRнֻʵս Excel 2021ʽѧϰ Excel͸ӱʵսؼ ľְ
øݴһ ݹߵİͷ ֱμ ExcelHomeƷ - VBA뱦
ChatGPTVBAһ㶨Excel WPSŵͨ Excel VBAʵָ
12һҳ
б
鿴: 7020|ظ: 10

[ԭ] ΪʲôҪѧϰaccess

[]

TAľ

TAĵ÷

2016-8-22 09:29 | ʾȫ¥ |Ķģʽ
һݹҵߣҪexcel+RʼϵͳѧϰaccessܽһЩݹҪѧϰaccessԵɣҵͬ£ڴ˷ķңʦָ㡣
ҷͬǵʼ

ǵexcelרҵˮƽ˵ڵˮƽڸиҵ棬excelݴVBAҪκһҹ˾㶼Եˡ
ݷĹһŻϣѧϵĹⲻһںţһʵʵѧϰ̡û˻Ϊרҵ֪ʶѾ㹻ḻˣʹĿǰȽţݿѧҡ

ݷҵ̣һռݴݷҪ2࣬1ͳƣ1ھԷڱȽеĻѧϰӦùھԷ棩γɱߡִоߵĹ̡
ҵ̣ÿһǺרҵġ
1ҵ//г⣬ҵ˼ά᳹ʼգȰרѾǸרҡгרһҵרˡʹûݼҲܵߡ
2ԼգͬҵвͬļҪҸո˵û˻ΪԼרҵ֪ʶѾ㹻ˣҪΪÿ̶һʵ֣һѼҪ죬ԣǻϣѧϵġѼרѾˣΪһ2࣬ݼ+̼Ϳϰٱݡ
12㶼רһݿѧңһʤϴܼࡢӪܼ֮ĸλȻڹ++϶Ǵţû30꣬ҲǺѵġο3к߽ܶݣ磺ѧֹۣӰеЩεġ
ص⣬ΪʲôҪѧϰaccess
֪excelݴݷϣݱظԵ/棬ǺƵģǣexcelмˣ1õݣϵͳITģϵͳģԣexcelڻȡDZģ㻹޷ҪITʲôݣϣܸʲô취ڴʵʲô2100вǼˣvbaôǿvbaҲһܺ˳3ɵݣITݣϵͳģԸʽʲôĶû⣬ֹдݣҪݽзǵĥǼܹݹЩдݣͷ۵ġ
ϼˣ˵excelǷdzģ˵ȥҲԵˡ
accessʲôأ
˵1ӣͬõҵϵͳAAʲôAAʵһݿϵͳһӴݿ⣨ǺϵͳǺĶԽӹAAĺ̨ݿ⣩AAݿϵͳǰ̨ע⣬Ҹո˸Ҫĸݿϵͳһ̨ݿ+һǰ̨ɵģԱͨAA(ǰ̨)ȡݣ޸ݣݣѯݡȻAADZȽϸӵģ֪ʶ⣬ԣϵͳԽӡ
ܵģ㿴ˣҵʼ죬ˡˣûм
ٿһϵͳҵʼ죬ҵСַȻԡѵĹ˾顣
飬AAһҪһ̨ݿ⣬һAAһǰ̨Ϳˡһ˵ݿĺ̨ǰֲ̨ͬļĿǰĺ̨Ҫǹϵݿ⼼ʵֵһѣSQL SERVER,MY SQL,ORACEL,DB2˳˵£ǵAAĺ̨DB2ģݿǰ̨ҲкܶࣨJSP,PHP,ASPȣںܶ๫˾ǰ̨ڵϰװֱ򿪣ǵºģļJAVApythonȡ
ôרҵDzǶҪˡҵһӹҲѧꡣãDzITרҵʿЩ֪ͺãҪͨ
ҵǣaccessȿԿݿǰ̨ҲԿݿĺ̨DzǺܸжһǰ̨ͨԡ
ȻҲһЩֻۣСģʹãٶȣݿСޣҵǣDzרҵԱǿݿϵͳΪʵһһϵм򵥵СܣҪAAӡ磬΢һaccessʿһһҵʼϵͳҵСַϵͳ
ΪʲôݷԱҪȥϵͳأصĻ⣬ûϵͳõݿܾ˹¼ģݾܰ˸裻ǴӴϵͳݣѹͲҪġǿһЩϵͳһҵ󡣴ϵͳôʯͷǽ棬п϶Dzܻ©ҵŶǽʱ򣬻ҪֹЩ©⣬accessСϵͳ൱һЩСʯͷһܿһaccessϵͳհǽ油룬ҵŶӸܵŶӴITάȷڶݷԱϵͳʹ÷Աܸ˽ҵ˽ݲ߼ҿԽҪֶηŽϵͳITơõݣȴӴϵͳмֵĶ࣬ΪֶεҵϵͳеĶ塣
Щaccessȥ
1صɢռݵijϡذ칫ܲɢ칫ݻܵҵ
2ûаڽϵͳСģ
3СģЭͬҵ
ϳaccessģǽ桢ϵͳοѧϰ
ظ

ٱ

TAľ

TAĵ÷

2016-8-24 19:18 | ʾȫ¥
[] Excelñ - ExcelIJЧ Excel / WPS             ʹð
ûдɣо⡣
ظ

ٱ

TAľ

TAĵ÷

 ¥| 2016-8-25 10:44 | ʾȫ¥

.......˼ҲǸѧaccessҲûʲôдġԣѾд.....
Ҫ....ڴ......
ظ

ٱ

TAľ

TAĵ÷

2016-8-25 12:39 | ʾȫ¥
ȣEXCELIJˣACEESSDzⷽ
ΣҪ룬EXCELﲻأѵ˼άƷ
DzĿĵIJһѡEXCELACCESS
أӦúʹȺʱˮƽͻ⣬Ƿ
ظ

ٱ

TAľ

TAĵ÷

 ¥| 2016-8-25 16:25 | ʾȫ¥
wgx711 2016-8-25 16:27 ༭
Renco 2016-8-25 12:39
ȣEXCELIJˣACEESSDzⷽ
ΣҪ룬EXCELﲻأѵ˼ά ...

excelЭǺģ磬Ҫһ֪ʶ⣬ܶͬʱʣҪͬʵģңڰٶҳͷṹչʾͳÿ˶֪ʶĵͣʱ䣬Ӷ֪Щ֪ʶǡȵЩ˶ЩıȽ϶࣬excelҲҪvba룬ҺڵάǺ鷳֪ʶˣԱ仯ˣڽԱĵ㡣
accessϵͳ׵Ķࡣ
ظ

ٱ

TAľ

TAĵ÷

2016-8-27 09:43 | ʾȫ¥
[] Excelñ - ExcelIJЧ Excel / WPS             ʹð
¥ѧϰACCESSֵÿ϶,ΪACCESSĺܶ๦ʵò,ʵEXCELĺܶ๦Ҳû,ʹACCESS˺,,벻սԼ˿Գȥѧϰ.
ظ

ٱ

TAľ

TAĵ÷

2016-11-15 23:02 | ʾȫ¥
ϵͳ˶ԣexcleĺʲô÷
ظ

ٱ

TAľ

TAĵ÷

2016-12-12 11:13 | ʾȫ¥
ظ

ٱ

TAľ

TAĵ÷

2016-12-29 12:56 | ʾȫ¥
[] Excelñ - ExcelIJЧ Excel / WPS             ʹð
䌍EXCELACCESS2ӲͬĖ|, Ӳ^Լѽݔһ
EXCELg:ԇ, 䌍һҊѪķg, ÁӋ, ģMõ
ACCESS:, ͺ, ǔ

˰H܇R܇T,lFHܵRHݰ,
THR, Hݰ, T߾Ƕ....
ظ

ٱ

TAľ

TAĵ÷

2017-1-4 23:10 | ʾȫ¥
[] Excelñ - ExcelIJЧ Excel / WPS             ʹð
ǰACCESS˸䷽ϵͳֺܶ˵ĵ϶װACCESSְEXCELʵһ顣ЩACCESSȽƣݹ淶ԣңݵȣݵͳƷӼ㡢ʹ÷棬EXCELȻơʲôˡϽһݹ黹ݿ⣬ݣEXCELõúþ͹ˡ
ܹʹVBAֵܸķߵããACCESSݣEXCELչʾݣǰҾôġ
ظ

ٱ

12һҳ
б

ֹ

ر

ȵһ /1 һ

ֻ||ϵ|ExcelHome

GMT+8, 2024-12-24 10:21 , Processed in 0.041729 second(s), 8 queries , Gzip On, MemCache On.

Powered by Discuz! X3.4

© 1999-2023 Wooffice Inc.

31011702000001 ICP11019229-2

̳۴߸κΥطɵۣվЭز׷Σ     վƸɹʣ־Ⱥʦ

ٻظ ض б