using vb.net to convert csv or txt file to MS Access table

[JH]

I have a comma delimited file and I want to export it to an MS access table
already designed with appropriate field names. How do I do this
programmatically using VB.NET ?

Thanks for any help in advance.

 

[Herfried K. Wagner [MVP]]

I have a comma delimited file and I want to export it to an MS access
table
already designed with appropriate field names. How do I do this
programmatically using VB.NET ?

<URL:http://www.connectionstrings.com/> contains samples for reading CSV
files and accessing Access databases.

Notice that there is a separate group for .NET+database available
(microsoft.public.dotnet.framework.adonet).

 

[Cor Ligthert]

Herfried,

Notice that there is a separate group for .NET+database available
(microsoft.public.dotnet.framework.adonet).

The ADONET newsgroup is for ADONET, not database questions with ADODB, so
maybe you can change your text a little bit. Because ADODB is as well
NET+database.

(serious meant message, nothing wrong to tell that there is an ADONET
newsgroup in this message, although your answer is not right)

Cor

 

[Cor Ligthert]

JH,

There are a lot of ways, with datasets etc. however I thought I have seen
that there is as well a direct way. And it is not impossible it is on this
page.

Access Automate
http://support.microsoft.com/default.aspx?scid=kb;EN-US;317113

For with a dataset gives Paul Clement very complete sample in this message
(dont look it is Oracle, Oledb is oledb) the only thing that changes is the
connection string and that link you got from Herfried.

http://groups.google.com/[email protected]

And please do not multipost, you can crosspost sending one message too the
in your opinion relevant newsgroups in one time.

I hope this helps a little bit?

Cor

 

[Cor Ligthert]

JH,

Ignore this answer (except the multiposting), I think that in the ADONET
newsgroup Gregorz has given a better answer.

Cor