Execute in SQL Server
Select * INTO BMK
From OpenDataSource ('Microsoft.jet.OleDb.4.0',
'Data Source = "E: / Share"; user ID = admin; password =; extended Properties = DBASE 5.0') ... BMK
This will import the BMK.DBF table in the E: / Share into the SQL Server.
The speed is the fastest
Tell everyone in the bottom of the pressure box
Place an Adoconnection on Form, linkage points to the target Access library
For example, TXT files in C: /Temp/aaaa.txt
Execute
Adoconnection.Connected: = true;
Adoconnection.execute ('Select * Into abcd from [text; database = c: / temp] .aaaa.txt');
Once everything is OK, this method must be done, I am very difficult to study.
With these two examples, the problem between the heterogeneous database is a non-three, and the blank is solved.
Import Excel into Access, similar to TXT
Select * INTO
