convert text to access mdb

  • Thread starter Thread starter jj
  • Start date Start date
J

jj

I have this comma delimited text file. I want to convert it in one sweep to
an access DB (mdb) format. I used the following code but it takes forever to
convert. Is there a faster way?

string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
strAppPath + "\\mydb.mdb";

OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd = new OleDbCommand("INSERT INTO mytable Select * from [Text;DATABASE="
+ strAppPath + ";].[mytextdata.txt]",conn );
cmd.ExecuteNonQuery();
conn.Close();


Any help is greatly appreicated and thank you in advance.
 
jj,

Post this message crossposted in the newsgroups

microsoft.public.dotnet.languages.vb.data
and
microsoft public.dotnet.framework.adonet

In those is Paul Clement active (is he here as well, however in that there
is less change that he missed it). This is typical a question for him. I
don't try even anymore these ones.

Cor
 
¤ jj,
¤
¤ Post this message crossposted in the newsgroups
¤
¤ microsoft.public.dotnet.languages.vb.data
¤ and
¤ microsoft public.dotnet.framework.adonet
¤
¤ In those is Paul Clement active (is he here as well, however in that there
¤ is less change that he missed it). This is typical a question for him. I
¤ don't try even anymore these ones.

Cor,

I already responded in one of the cross-posted groups.


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top