"0100000000002013030003","陳明的","陳明的","1","1963/10/13","1963/10/13","3223339631013301X","110108","地址地址地址地址地址地址","110108","北地址地址地址地址地址地址四單元601室","","","",""," ","444013030003","080000","2013/01/01"," "," ","500","02","010000","ff寺地","010-1234567",
"0201000009992012060001","張超明","張超明","1","1978/01/08","1978/01/08","144422301086036","110106","地址地址地址地址地址地址","310115","世地址地址地址地址地址地址1405室","11","444447801080559","",""," ","444992012060001","030456"," "," ","B級 ","20000","01","020100","陳琳","13512344565",
"1105280009992006030003","崔活力","崔活力","1","1955/05/20","1955/05/20","1444450520423","120105","天地址地址地址地址地址地址4室","120105","天地址地址地址地址地址地址里1號樓2門504室","","","","","170","44555002006030003","050720","2000/05/16"," "," ","500","02","110528","楊磊","1312344153",
"1105280009992006030002","王義","王義","1","1957/10/16","1957/10/16","1422323210162557","110104","廣地址地址地址地址地址地址3號樓602","110104","廣地址地址地址地址地址地址3號樓602","","","",""," ","1455332006030002","080000"," "," "," ","500","02","110528","陳地","135245205912",
"1105280009992006060011","郭一","郭一","1","1966/04/18","1966/04/18","1553496604188913","110108","清地址地址地址地址地址地址202號","110108","清地址地址地址地址地址地址202號","","","",""," ","1105280355353060011","080000"," "," "," ","1000","02","110528","地桶","13912384",
"1105280009992006060012","江旗","江旗","1","1976/02/16","1976/02/16","353447602161558","330822","天馬地址地址地址地址地址地址36棟東單元302室","110105","潤地址地址地址地址地址地址座1306","","","","","170","1105280003560012","080000","2006/03/01"," "," ","1000","02","110528","們進","11233441081",
"1105280009992006090015","王冬","王冬","1","1956/11/07","1956/11/07","1334434395611074936","110108","復地址地址地址地址地址地址12層1號","110108","地址地址地址地址地址地址棟12層1號","","","",""," ","110355306090015","080000"," "," "," ","500","02","110105","王備","13391861320",
"1105280009992006110018","辛左衛","辛左衛","1","1957/06/30","1957/06/30","15533445706304239","110108","中地址地址地址地址地址地址號院47單元1號","110108","地址地址地址地址地址地址街5號院47單元1號","","","","","165","1105280009992006110018","050720"," "," "," ","1000","02","110528","張小明","134564444",
"1105280009992006120019","胡波","胡波","1","1976/03/24","1976/03/24","6553437603243437","510104","靜安地址地址地址地址地址地址單元102號","110108","地址地址地址地址地址地址棟1門1201號","","","",""," ","1135006120019","050720"," "," "," ","1000","02","110528","劉景","1315644731",
"1105280009992007040008","玉普","玉普、玉普","1","1967/06/04","1967/06/04","255334306041314","110108","太地址地址地址地址地址地址號樓2201號","110108","地址地址地址地址地址地址樓2201號","34","G08309286","","","172","1103592007040008","080000"," "," "," ","500","02","110528","高春明","13445677874",
"1105280009992007050009","雷大師","雷大師","1","1956/02/13","1956/02/13","1155335602132390","110102","地址地址地址地址地址地址樓1門6號","110102","地址地址地址地址地址地址門6號","34","G08301114","28","T00355875","184","135007050009","080000","2007/04/11"," "," ","1000","02","110528","曲明","13033212851",
"1105280009992007080012","大江","大江","1","1970/04/09","1970/04/09","155553404095019","110101","臺地址地址地址地址地址地址5樓3門10號","110101","地址地址地址地址地址地址門10號","34","G04013070","42","W00783232"," ","1105280009992007080012","080000"," "," "," ","1000","02","110528","賈2海","0281551638",
"1105280009992007100015","劉大壯","劉大壯","1","1973/03/14","1973/03/14","1166666303144532","110108","北地址地址地址地址地址地址3門7號","110106","地址地址地址地址地址地址樓701室","","","","","170","135580009992007100015","050720"," "," "," ","500","02","110528","梁2","13524808",
"1105280009992007120019","梁祝","梁祝梁祝","1","1963/07/14","1963/07/14","110144433307140054","110101","史地址地址地址地址地址地址2號","110101","地址地址地址地址地址地址號","42","W06487560","34","09822114"," ","1105280009992007120019","080000"," "," "," ","1000","02","110528","崔楠","0112652",
檔案格式如上
資料將近30W條
如何能快速匯入到Access資料庫
uj5u.com熱心網友回復：
大資料操作最好用資料庫自身的功能。Access 的匯入操作記得不能在外部呼叫；還是手工打開 Access，用 csv 格式匯入吧。
uj5u.com熱心網友回復：
Access自帶外部資料匯入你的文本資料可以按","分隔 匯入
PC上沒有ACCESS，用EXCEL試了你的文本可以匯入。
實在不行先匯入EXCEL再匯入ACCESS 這也是可以的
uj5u.com熱心網友回復：
用vb做的一個小工具
好多人不會使用access、
所有做了個工具軟體
不知道有什么思路
uj5u.com熱心網友回復：
從來沒有使用過那玩意兒，不熟悉啊。這個我先圍觀一下……
uj5u.com熱心網友回復：
我覺得樓主應該把問題說得明白些：你現在是如何操作的、速度如何（完成匯入要多少秒）？
這個方法你覺得有哪些不足的地方？
你說的“快速”，你是期望快到那種程度？
另外就是，打開Access后，用它可以匯入，
那它要多少秒完成？（如果你想比這個還快，多半不現實）
你可以用access物件來操作不？
（這個就必須要安裝Office的Access產品。通過COM介面操作）
可以用支持Access檔案的“資料庫物件”來操作不？
uj5u.com熱心網友回復：
最早的也是用access匯入的整個匯入程序大概在6、7秒左右
有時候在其他電腦操作并沒有裝access，匯入資料特別麻煩
所以想到做個工具
剛開始想到用BULK INSERT，發現access不支持
不過我在sql server測驗BULK INSERT效果還真不錯，整個匯入程序5秒左右完成，如果做索引估計速度還能提升一點（還未測驗）
有人告訴我把txt文本當作資料庫來處理
找半天沒找到相關的說明
我這里打不開msdn網站
我在試試open input回頭告訴結果
今晚就先睡覺 明天繼續
我的預期目標是能在15之內匯入到庫
COM介面就放棄吧，好多電腦都沒有裝access
uj5u.com熱心網友回復：
碰到個問題比如下列資料
"1105280009992007120019","梁祝","梁祝梁祝","1","1963/07/14","1963/07/14","110144433307140054","110101","史地址地址地址地址地址地址2號","110101","地址地址地址地址地址地址號","42","W06487560","34","09822114"," ","1105280009992007120019","080000"," "," "," ","1000","02","110528","崔楠","0112652,123123,123333",
注意最后一個欄位
"0112652,123123,123333",
如果我用逗號做分隔符 遇到這樣的列取得資料就不全了
不知道怎么用","做分隔符
uj5u.com熱心網友回復：
CSV 格式兩邊有雙引號會當作一個欄位處理的。uj5u.com熱心網友回復：
用資料庫方式讀文本參考這個帖子uj5u.com熱心網友回復：
也就是 你這個 txt 本身就沒有 太強的 規律性，
即使 匯入了 CSV 你也得到的 是不正確的 資料整合。
uj5u.com熱心網友回復：
路過，過來看看有什么uj5u.com熱心網友回復：
打開txt用Line Input #1, NextLineuj5u.com熱心網友回復：
如果你用外部資料庫的匯入方式，這個不會有影響。如果你是采用行讀入后 Split 分割欄位的，可以改成tmp = Split(strLine, """,""")
uj5u.com熱心網友回復：
我按順序讀取拆分的，樓主不妨一試。沒測驗過大資料，應該不會卡死吧，不知道效率如何。
uj5u.com熱心網友回復：
先編程把檔案變為access匯出格式，再在access界面匯入uj5u.com熱心網友回復：
這應該就是一個csv格式的檔案了, 你新建一個access資料庫, 然后直接在access中選擇匯入資料功能, 有csv選項轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/110947.html
標籤：VB基礎類
上一篇：vb 對注冊表授權 求 regsetkeysecurity 函式用法
下一篇：Josephus在VB中的實作