import data from csv file

[a]

Dear friends

I want import data from CSV file to mdb file How can I do that in vb.net?

[rowe_newsgroups]

On Jul 26, 4:50*am, "a" <[e-mail] e:

Dear friends

I want import data from CSV file to mdb file How can I do that in vb.net?

ADO.NET

Thanks,

Seth Rowe [MVP]
http://sethrowe.blogspot.com/

[a]

tell me the steps (the answer)
Thank you
"rowe_newsgroup s" <ro********@yah oo.comwrote in message
news:00******** *************** ***********@34g 2000hsf.googleg roups.com...
On Jul 26, 4:50 am, "a" <[e-mail] e:

Dear friends

I want import data from CSV file to mdb file How can I do that in vb.net?

ADO.NET

Thanks,

Seth Rowe [MVP]
http://sethrowe.blogspot.com/

[Family Tree Mike]

No one is likely to do that. You haven't specified the problem completely
enough for anyone. For example, are the columns of data well defined or do
you need to determine them at runtime by reading the CSV first? You are
more likely to get an answer if you show where you are stuck in your code.
If you ask for the entire answer without showing your attempt, it will be
more likely for others to think you simply want your homework done for you.

By the way, please don't multipost. There are other answers on
..Dotnet.Genera l where you asked this.

"a" <[e-mail] in message
news:O7******** ********@TK2MSF TNGP02.phx.gbl. ..

tell me the steps (the answer)
Thank you
"rowe_newsgroup s" <ro********@yah oo.comwrote in message
news:00******** *************** ***********@34g 2000hsf.googleg roups.com...
On Jul 26, 4:50 am, "a" <[e-mail] e:

>Dear friends

I want import data from CSV file to mdb file How can I do that in vb.net?

ADO.NET

Thanks,

Seth Rowe [MVP]
http://sethrowe.blogspot.com/

[rowe_newsgroups]

First off, community support does not exist to solve your every
problem with no work from you. In general, I will give you (or
whoever) enough guidance to get started on the path to the solution,
but I will not do it for you, otherwise you will never learn. With
that said, I will honor your request and give you the steps you
requested, in a sarcastic tone.

Steps:

1) Buy a book on ADO.NET
2) Apply what you have learned to fix your problem.

Thanks,

Seth Rowe [MVP]
http://sethrowe.blogspot.com/

[Gillard]

by just having a look at the code project web site and searching CSV you can
find what you are looking for
"a" <[e-mail] in message news:O7******** ******@TK2MSFTN GP02.phx.gbl...

tell me the steps (the answer)
Thank you
"rowe_newsgroup s" <ro********@yah oo.comwrote in message
news:00******** *************** ***********@34g 2000hsf.googleg roups.com...
On Jul 26, 4:50 am, "a" <[e-mail] e:

>Dear friends

I want import data from CSV file to mdb file How can I do that in vb.net?

ADO.NET

Thanks,

Seth Rowe [MVP]
http://sethrowe.blogspot.com/

[a]

Dear friends

I'm not strong vb.net programmer I'm just take course and I want to learn
from you

And I have Excellent knowledge of access 2003 (Expert)

In access 2003 to import data from CSV file you just select file import and
select text

And all CSV file will import in a new table with some steps with the wizard

know I want just import data from CSV file to Access using VB.NET

by button in vb.net form just click this button the vb.net imports data from
csv file to access mdb file

Mr. Paul

Microsoft MVP (Visual Basic)

give me this code :

Dim AccessConn As New
System.Data.Ole Db.OleDbConnect ion("Provider=M icrosoft.Jet.OL EDB.4.0;"
& _
"Data Source=C:\Test Files\db1 XP.mdb")

AccessConn.Open ()

'New table
Dim AccessCommand As New System.Data.Ole Db.OleDbCommand ("SELECT *
INTO [TextFileTable] FROM
[Text;DATABASE=C :\Documents and Settings\...\My Documents\My
Database\Text].[Textfile.txt]",
AccessConn)
'Existing table
'Dim AccessCommand As New System.Data.Ole Db.OleDbCommand ("INSERT
INTO [TextFileTable] (F1,
F2, F3, F4, F5) SELECT F1, F2, F3, F4, F5 FROM [Text;DATABASE=C :\Documents
and Settings\...\My
Documents\My Database\Text].[Textfile.txt]", AccessConn)

AccessCommand.E xecuteNonQuery( )
AccessConn.Clos e()

But there is error in the code I can't benefit form this code

The error in sql code

I'm edit this code like this but also there is error in sql code:

Dim cn As New OleDbConnection

cn.ConnectionSt ring = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=test.mdb ;Persist Security Info=False"

cn.Open()

Dim cmd As New OleDbCommand

cmd.CommandText = ("SELECT * INTO [TextFileTable] FROM [Text;DATABASE=
E:\a.csv]")

cmd.Connection = cn
cmd.ExecuteNonQ uery()

cn.Close()

==

Can you edit the code for me







"Gillard" <gillard_george s@@@@@@@@@hotma il.comwrote in message
news:OM******** ******@TK2MSFTN GP02.phx.gbl...

by just having a look at the code project web site and searching CSV you
can find what you are looking for
"a" <[e-mail] in message
news:O7******** ******@TK2MSFTN GP02.phx.gbl...

>tell me the steps (the answer)
Thank you
"rowe_newsgrou ps" <ro********@yah oo.comwrote in message
news:00******* *************** ************@34 g2000hsf.google groups.com...
On Jul 26, 4:50 am, "a" <[e-mail] e:

>>Dear friends

I want import data from CSV file to mdb file How can I do that in
vb.net?

ADO.NET

Thanks,

Seth Rowe [MVP]
http://sethrowe.blogspot.com/

[Cor Ligthert [MVP]]

a,

It is important that you tell us if you want to use an import in an existing
database or a new database table.

As you are an expert in Access, you would no the reason.

That there is nothing simple is probably because that Jet is a little bit
out of the focus and everything is now SQL Server, where is a simple
BulkCopy (Although I see that this will be replaced)

For OleDB you have in fact simple to get a DataSet using the connection and
the Fill from CSV and then use that DataSet by looping through the resulted
datatable and then update your database that you have filled first.

For the update you can simple use the commandbuilder.

Cor

"a" <[e-mail] ef in bericht
news:ed******** ******@TK2MSFTN GP03.phx.gbl...

Dear friends

I want import data from CSV file to mdb file How can I do that in vb.net?

[Cor Ligthert[MVP]]

no = know

Sorry

Cor
"Cor Ligthert [MVP]" <no************ @planet.nlschre ef in bericht
news:On******** ******@TK2MSFTN GP02.phx.gbl...

a,

It is important that you tell us if you want to use an import in an
existing database or a new database table.

As you are an expert in Access, you would no the reason.

That there is nothing simple is probably because that Jet is a little bit
out of the focus and everything is now SQL Server, where is a simple
BulkCopy (Although I see that this will be replaced)

For OleDB you have in fact simple to get a DataSet using the connection
and the Fill from CSV and then use that DataSet by looping through the
resulted datatable and then update your database that you have filled
first.

For the update you can simple use the commandbuilder.

Cor

"a" <[e-mail] ef in bericht
news:ed******** ******@TK2MSFTN GP03.phx.gbl...

>Dear friends

I want import data from CSV file to mdb file How can I do that in vb.net?

[Kevin S Gallagher]

Your best course of action is to research the task at hand using Google. My
approach would be to discover how to read the CSV file into a collection
which can be looped though for data correctness then when this is done use
OleDb components to store the data.

The best advice after searching and reading MSDN documentation is to ask
your question here supplement your question with snippets of code so the
experts here can assist you.

Why not break down the objective as follows; read a text file line by line
i.e. System.IO.Strea mReader, Loop thru this data, parse the data perhaps
using Regular expressions followed by validating and pushing the data to the
Access database using OleDb components.

Good luck :-)

"a" <[e-mail] in message news:u6******** ******@TK2MSFTN GP04.phx.gbl...

Dear friends

I'm not strong vb.net programmer I'm just take course and I want to learn
from you

And I have Excellent knowledge of access 2003 (Expert)

In access 2003 to import data from CSV file you just select file import
and select text

And all CSV file will import in a new table with some steps with the
wizard

know I want just import data from CSV file to Access using VB.NET

by button in vb.net form just click this button the vb.net imports data
from csv file to access mdb file

Mr. Paul

Microsoft MVP (Visual Basic)

give me this code :

Dim AccessConn As New
System.Data.Ole Db.OleDbConnect ion("Provider=M icrosoft.Jet.OL EDB.4.0;"
& _
"Data Source=C:\Test Files\db1 XP.mdb")

AccessConn.Open ()

'New table
Dim AccessCommand As New System.Data.Ole Db.OleDbCommand ("SELECT *
INTO [TextFileTable] FROM
[Text;DATABASE=C :\Documents and Settings\...\My Documents\My
Database\Text].[Textfile.txt]",
AccessConn)
'Existing table
'Dim AccessCommand As New System.Data.Ole Db.OleDbCommand ("INSERT
INTO [TextFileTable] (F1,
F2, F3, F4, F5) SELECT F1, F2, F3, F4, F5 FROM
[Text;DATABASE=C :\Documents and Settings\...\My
Documents\My Database\Text].[Textfile.txt]", AccessConn)

AccessCommand.E xecuteNonQuery( )
AccessConn.Clos e()

But there is error in the code I can't benefit form this code

The error in sql code

I'm edit this code like this but also there is error in sql code:

Dim cn As New OleDbConnection

cn.ConnectionSt ring = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=test.mdb ;Persist Security Info=False"

cn.Open()

Dim cmd As New OleDbCommand

cmd.CommandText = ("SELECT * INTO [TextFileTable] FROM [Text;DATABASE=
E:\a.csv]")

cmd.Connection = cn
cmd.ExecuteNonQ uery()

cn.Close()

==

Can you edit the code for me







"Gillard" <gillard_george s@@@@@@@@@hotma il.comwrote in message
news:OM******** ******@TK2MSFTN GP02.phx.gbl...

>by just having a look at the code project web site and searching CSV you
can find what you are looking for
"a" <[e-mail] in message
news:O7******* *******@TK2MSFT NGP02.phx.gbl.. .

>>tell me the steps (the answer)
Thank you
"rowe_newsgro ups" <ro********@yah oo.comwrote in message
news:00****** *************** *************@3 4g2000hsf.googl egroups.com...
On Jul 26, 4:50 am, "a" <[e-mail] e:
Dear friends

I want import data from CSV file to mdb file How can I do that in
vb.net?

ADO.NET

Thanks,

Seth Rowe [MVP]
http://sethrowe.blogspot.com/