convert text to access mdb

6 Feb 2006 4:57 PM

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.

7 Feb 2006 6:45 AM

Cor Ligthert [MVP]

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

9 Feb 2006 2:18 PM

Paul Clement

On Tue, 7 Feb 2006 07:45:17 +0100, "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote:

¤ 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)