"0100000000002013030003", "Chen Ming", "Chen Ming", "1", "1963/10/13", "1963/10/13", "3223339631013301 x", "110108", "address address address address", "110108", "north address address address address four unit 601 room", ""," ", ""," ", ""," 444013030003 ", "080000", "2013/01/01", ""," ", "500", "02", "010000", "ff temple", "010-1234567,"
"0201000009992012060001", "Zhang Chaoming Zhang Chaoming", ""," 1 ", "1978/01/08", "1978/01/08", "144422301086036", "110106", "address address address address", "310115", "the address address address address, room 1405", "11", "444447801080559", ""," ", ""," 444992012060001 ", "030456", ""," ", "B", "20000", "01", "020100", "Chen Lin", "13512344565",
"1105280009992006030003", "vigor" cui, "cui vitality", "1", "1955/05/20", "1955/05/20", "1444450520423", "120105", "day address address address address 4 room", "120105", "day address address address address in 1 floor, room 504, 2 door", ""," ", ""," ", "170", "44555002006030003", "050720", "2000/05/16", ""," ", "500", "02", "110528", "Yang", "1312344153",
"1105280009992006030002", ". ", "".", "1", "1957/10/16", "1957/10/16", "1422323210162557", "110104", "wide address address address address no. 3 floor 602", "110104", "wide address address address address no. 3 floor 602", ""," ", ""," ", ""," 1455332006030002 ", "080000", ""," ", ""," 500 ", "02", "110528", "Chen", "135245205912",
"1105280009992006060011", "guo", "guo an", "1", "1966/04/18", "1966/04/18", "1553496604188913", "110108", "qing address address address address 202", "110108", "qing address address address address 202", ""," ", ""," ", ""," 1105280355353060011 ", "080000", ""," ", ""," 1000 ", "02", "110528", "drum", "13912384",
"1105280009992006060012", "Jiang Qi Jiang Qi", ""," 1 ", "1976/02/16", "1976/02/16", "353447602161558", "330822", "tianma address address address address 36 building room 302, east yuan", "110105", "s address address address address 1306", ""," ", ""," ", "170", "1105280003560012", "080000", "2006/03/01", ""," ", "1000", "02", "110528", "into", "11233441081",
"1105280009992006090015", "wang dong", "wang dong", "1", "1956/11/07", "1956/11/07", "1334434395611074936", "110108", "double address address address address 12 layer 1", "110108", "address address address address building 12 layer 1", ""," ", ""," ", ""," 110355306090015 ", "080000", ""," ", ""," 500 ", "02", "110105", "Wang Bei", "13391861320",
"1105280009992006110018", "xin left-back," "xin left-back", "1", "1957/06/30", "1957/06/30", "15533445706304239", "110108", "address in the address address address, 47 unit no. 1", "110108", "address address address address street 5 yuan 47 unit no. 1", ""," ", ""," ", "165", "1105280009992006110018", "050720", ""," ", ""," 1000 ", "02", "110528", "Zhang Xiaoming", "134564444",
"1105280009992006120019", "huber huber", ""," 1 ", "1976/03/24", "1976/03/24", "6553437603243437", "510104", "jing 'an address address address address unit 102", "110108", "address address address address 1 gate house 1201", ""," ", ""," ", ""," 1135006120019 ", "050720", ""," ", ""," 1000 ", "02", "110528", "Russell", "1315644731",
"1105280009992007040008", "yupu," "jade, jade agency", "1", "1967/06/04", "1967/06/04", "255334306041314", "110108", "too address address address address building 2201", "110108", "address address address address floor 2201", "34", "G08309286", ""," ", "172", "1103592007040008", "080000", ""," ", ""," 500 ", "02", "110528", "chun-ming gao", "13445677874",
Master of "1105280009992007050009", "ray", "master", "1", "1956/02/13", "1956/02/13", "1155335602132390", "110102", "address address address address floor 1 door 6", "110102", "address address address address door 6", "34", "G08301114", "28", "T00355875", "184", "135007050009", "080000", "2007/04/11", ""," ", "1000", "02", "110528", "events", "13033212851",
"1105280009992007080012", "river" and "river", "1", "1970/04/09", "1970/04/09", "155553404095019", "110101", "Taiwan address address address address 10 5 floor 3 door", "110101", "10 address address address address door", "34", "G04013070", "42", "W00783232", ""," 1105280009992007080012 ", "080000", ""," ", ""," 1000 ", "02", "110528", "jia hai 2", "0281551638",
"1105280009992007100015", "liu", "liu", "1", "1973/03/14", "1973/03/14", "1166666303144532", "110108", "north address address address address 3 door 7", "110106", "address address address address floor, room 701", ""," ", ""," ", "170", "135580009992007100015", "050720", ""," ", ""," 500 ", "02", "110528", "beam 2", "13524808",
"1105280009992007120019", "butterfly lovers", the butterfly lovers "butterfly lovers", "1", "1963/07/14", "1963/07/14", "110144433307140054", "110101", "s address address address address no. 2", "110101", "address address address address number", "42", "W06487560", "34", "09822114", ""," 1105280009992007120019 ", "080000", ""," ", ""," 1000 ", "02", "110528", "Cui Nan", "0112652",

The file format as above
Article data nearly 30 w
How can quickly into the Access database

CodePudding user response:

Big data operation had better use the function of the database itself,
Access import operation remember not outside calls; Or manual open Access, import a CSV format,

CodePudding user response:

The Access cabin external data import

Your text data can press ", "separate import

PC no ACCESS, using the EXCEL your text can be imported,

Was not the guide into EXCEL import ACCESS again it is also possible

CodePudding user response:

reference 1st floor Tiger_Zhao response:

big data operation had better use the function of the database itself,
Access import operation remember not outside calls; Or manual open Access, import a CSV format.

Using vb to do a small tool
Many people won't use access,
All made a tool software
I don't know what's the idea

CodePudding user response:

Never use the thing, not familiar with,
The first I check out...

CodePudding user response:

I think the building Lord should say clearly the problem:
How you now is how to operate, speed (complete import to how many seconds)?
What are the insufficient place this method do you think?
You say "fast", you are fast to the extent that expectations?

Another is that open Access, use it can be imported,
Then, how many seconds to finish it? (if you want to faster than this, most unrealistic)
You can use the access object to operate?
(this will have to install Office Access products, through the COM interface operations)
Can be used to support the Access of the document "database objects" to operate?

CodePudding user response:

The earliest is also made of access import
The whole import process in about six or seven seconds
Sometimes in other computer operation and no access, import data special trouble
So think of a tool
Just began to think of using BULK INSERT, found the access does not support the
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull