Asp+AccessӦͨͨÿԳɼϵͳ(ѯ):Windows(gbk)ʹ˵
汾ͺ ҳ汾 ϵͳ ݿ ݿģ ʾ Դ ֽ̳ Ƶ̳
AA1A Asp Ӧͨ Windows(gbk) Access 5*N 2023/11/28 0:43:48 ʾ ע° ½̳

ȳԿ

Ȳ޸κֱFTPϴӦռԡ
ѯҳʣhttp://ַ/Ŀ¼/ (ϴֱʹmysql)

޸IJ

notepad++inc/conn.Asp鿴ҳĶӦϵ
⣺incļļΪdesc.txtΪѯҳ˵ļ(֧html)

ݿ

ĬԴݿ鿴ɼԱȲѯڿ⹤ԭ
asa򿪷ʽaccessݿ⣬ĺ׺Ϊ.mdbMs Access򿪡

Ҫ

ںƴ󲿷߽ѹļ룬FTPָ루gb2312ϴ
鱣ԭʼ汾ҳ棺ԭʼ汾Լ޸ĺ쳣˵⡣
ѹںʹò裻ļڵ彨鱣

߱

ӲҪ

վԴ룬㻹Ҫվռ䡢վڿռ㻹ҪŲ/վ(ܺʱ)
Ӳ˵ѹһhtmlʽļShiYongShuoMingShu_****.html
ʹǵ߰汾ٶȣְ(chalide.cn) ײн(chalide.com)

ҪԱʹߣ߱FTP󶨡վռʹáexcelȼܡ
ãȻҪϸģؾѣ羭ʹá

ԭ

ҵʹñԴ룬ǰǣȥȨϢȨ
ԶοԸõķ󣬵ãȨ

xlsʽά

а汾ݶ˵ƽʱ༭xlsʽάֻDzѯʱӦת

ϷϹʹ

ϷϹʹñѯϵͳߡضѡ

ʹ;

ʺ޸IJƵԲߵɼʡҵˮѵȸ־׼ѯ
ģο׼ѯ棬˵ģѯ;ȡ

ɼѯϵͳ

ÿѧУ,,ҵλԵȶõ

ʲѯϵͳ

ÿѧУ,,ҵλԵȶõ

ҵѲѯϵͳ

ÿҵ,ѧУ,еλõ

ˮѲѯϵͳ

С,ҵ˾,ѧҵ

ְѯ,¼ȡѯ,ѯ֤ѯ޸IJĸֲѯϵͳ

ض

1.ϴӦزšλͬ⡣

Ϊ˹ܷգͬ¡쵼СΧѯ飬ͬٹѯ

2.ָݼչֽòѯ

ѧ+Уôֻ飬ΪͬĶᶼʾ

3.ֻϴݣϴ޹صĸ˽Ϣ

ͨѧ+ѯɼͱϴ֤š绰޹Ϣ

4.ϴ벻Ҫ۵㡣

ںѯȴIJѯ;

5.ϷϹʹá

𽫱ϵͳΧIJѯ;
ҪðʹãײλϢ

6.ݵķش

޸conn.AspݿļΪԼ֪ͬʱ޸ĶӦļơ
α̬ȷʽøݿļ׺ļвء

ʹò

޸

1.±inc/conn.asp޸վ⡢ѯȲ,ļ˵

ת

οʵοĬԴݹɣ鱣ԭʼݹԺο
1.MS accessxlsάcsvάҪaccessݿƼʹá

Դϴ

1.Դϴԭнṹϴվֱʹãϴעָ루gb2312ϴ
2.Ƽϴfilezilla(ָϴ)Ƽ߽ѹļѹ롣
߽ѹ룺޸ļΪĺԣʵڲоʹӢļ

ϴ

1.ϴʽFTPϴƼԶϴļ߹ȡ
2.ָͨ루ַgb2312ϴݣϴվݿĿ¼¡
3.ѯϴһݡע׺ԭһ¡ѯҪinc/conn.Aspõһ
4.ٲѯɾݿĿ¼¶Ӧļ
5.IJѯӦļ
6.޸ݣϴת滻ԭͬݡ

رǿ(ά)

1.ֻ֧һб⣺бϲΪһУ൱Ϊÿֻб⣩
2.ֺ֧ϲԪ񣺲ֵԪѸԪǰݡ
3.ݲοҳβά淶

òѯ

ѯýʹ/ѧ/׼֤/֤/ŵ,ð༶ȿжݡ

ԴСɿԶ򿪿

пвǵַ±򿪶Ӧļ滻ΪԼַɡûаվͲҪ޸ġ

ݵһЩ˵

룬޸ģʹ֤עСдͳһΪд,ôҳ˵£
ŵΪѯΪᱻת(ոᱻ ),ոĻ滻

ѯģ˵

Ƽ¼,Ӱٶȣ鱣ÿݿļ5ڣ˿Էֿ⣺ּݿš

ǰ˵

ںƴ󲿷߽ѹļ룬FTPָ루gb2312ϴ
鱣ԭʼ汾ҳ棺ԭʼ汾Լ޸ĺ쳣˵⡣
ѹںʹò裻ļڵ彨鱣

ྭʾ

1. ԭʼ汾ʮа˾⡣
Խ㱣ԭʼ汾ԷͬռԶԱȷжԭ
2. ڶӦʹãرPHPϵͳ汾
IISΪWINDOWS汾windowsµNGINXapacheѡlinux档
3. PHP5.4-5.6ʹ
󲿷ְ汾php7Ҳãųְ汾֧PHP7.0+
xls汾ļȡ쳣ԽPHP汾ԡ
4. ռʹñԴ
ľͰԭݲͬԴ룬һݰȫϵͱڣԴ뼰Ҳᱻ
кܶԴԼα̬򣬻ԴС
5. ߽ѹԴ룬ƼFTPʽ
߽ѹرlinuxļѺãϴļ
߽ѹõļļеȨ޿ܻԱȨޣWWW޷д

ɫ

1. ͨ

ԴСݿ⣬Կڸֶάѯ
ɼѯˮҵѲѯ¼ȡְࡢᡢѯͨá

2. Сչ

Դ루ʾݣֻ30-50KBȻ
ڳԱգٶȲͶοɱ

3. Ϊȫ

Դֻҳ棬ֻдûsqlעȷա
ǰǼʮMBļԽԽӣȫԽա

4.

谲װʼҲ޸IJŸĿ¼Ŀ¼ֱʹá
FTPʵֺ̨ܣϴռ伴ʹá
FTPϴݿܸķԴҲռϴСͳʱʱȡ
FTPϴɶļһȫϣֶ֧ϵȣԷӰС
ɾ˵ļFTPɾ

5. ͺڴ

Mysql(󲿷Ϊdzݿ)ڴҲ(Mysqlܶ20%+ڴ)

6. ͺ

ڴҳ浥jsļͼKBͼƬ͸ˡ
һҳ1MBѯҳһҳֻ30KBҡ
൱ͬȴԴ£粢ʮ
ĿǰơѶƵ8MBʵ1MBĴ1000Ԫÿꡣ
ԣʡܶõͬʱѯIJ

7. ͺĶд

ѯֻдСɵҳҲJSͼƬĶȡԼԴ

˵

˵

1. ޸ԽƵԽʺ(ɼʡˮѵһ㶼һԳ޸)
2. ֻʺ϶ά(һݿⶼöάṹ,б,Ժһһ)
3. Ƶ¼鵥5ڣɷֿ⣬⻥Ӱ죩
4. ֧ͼƬַС23ѯ ( http://php.96448.cn )
5. Ѱ涼޺̨Ҫ̨( http://phpa.96448.cn )
6. ߼ģѯ汾 ( http://phpso.96448.cn )
7. ˺¼ѯȰ汾 ( https://aiyaha.taobao.com/ )
8. ָʽ׺ܻᱻأ÷شŶ
'ٶȣIISýֹ.csvʽ ʽУα̬ʽļȨޣ׺ӳ

Դ

ѹShiYongShuoMingShu_****.htmlʽ˵飬ͬݡ
øѼ֧֣https://aiyaha.taobao.com/
عߣ滻ƱеĿ http://d.chalide.cn/xls2txt/xls2txt.zip

Դʹ

ʹǵ ð汾ٶȣְ ײн
ռ 輼Ա 豸
ʱͨ ,ṩƽ̨,
Сû(󲿷Сѧ)ڿɷ꼶ϴ࿪ѯϵͳ

绰15058593138ͬ΢źţ
ͨṩ汾Ϣ AA1A ͼ
ͨЧݣΪ˫ʡܶʱ䡣

Ѽ֧

踶Ѽ֧Ʋhttps://aiyaha.taobao.com
΢ 15058593138 һָΪʡСʱʱ䡣

ͬռ䲻ͨ

inc/conn.aspͷУ
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%Session.CodePage=936%>

רҵнӸѯйܷ

ά淶

άṹ

excelһǸб⣬Ժһһ

Ӧþ߱Ĺ

1. ֻеһΪб⣨ҲֶΣбȺϲΪһС
2. ϴֶεðΪѯ(ҵõIJѯ)
3. ɾɾǶάݣֻݵľ򣩡
4. ڶпʼÿһÿͬѧжѧţЧ
5. άڻسƱ滻忴̡̳

txt 絥ԪسƱ滻

1. ʽһֱexcel滻ctrl+H ȡ滻߽̳ ٶؾ顣
ݴ롾סALT10ٷſaltȻ滻ͬ\汾ݿܲͬٶȡ
2. ʽʽ滻=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Sheet1!A1,CHAR(13),";"),CHAR(10),";"),CHAR(9),";")
Sheet1DZA1Aе1еԪ;Sheet1108У¿ձ1빫ʽȻõԪ½+ţȻ108еõ±
3. ʽasp滻ߣhttp://96448.cn/xls2txt/xls2txt.zip
asp߱netboxУxlsļָļУˢ·ʹַѡӦļύõtxt
4. ʽģphp(csvתtxt滻سƱ)http://tool.chalide.cn/ (ת)
5. ʽ壺php(csvתtxt滻سƱ)http://tool.chalide.cn/down.php (Լ)
6. ʽphp(ճתtxt滻سƱ)http://teel.chalide.cn/ (ת)
7. ʽߣphp(ճתtxt滻سƱ)ϵ15058593138@qq.comȡ (Լ)

ʼ(ȥʽ)

xlsѯ޷ʶݣִ²
1. Excelάṹֵ±
2. ½ExcelȫѡҼ õԪʽ ָʽѡı
3. ȫѡ±ݲƵղŴexcel档