import data from CSV

[a]

Dear friends

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

 

[Family Tree Mike]

Which steps do you have problems with? There are numerous examples of
creating and adding data to access databases. I would read the CSV into a
list of a list of strings, with File.ReadAllLines and String.Split.

 

[Cor Ligthert[MVP]]

Hi,

In this case it has nothing to do with US.

In English the dot is a decimal point seperator and the comma for thousands

In all other European languages that is a comma for decimal point (it has
that name of course not in those languages) and a dot as comma seperator.

Cor

 

[Andrew Faust]

Which steps do you have problems with? There are numerous examples of
creating and adding data to access databases. I would read the CSV into a
list of a list of strings, with File.ReadAllLines and String.Split.

This method won't actually let you read many CSV files. If comma or carriage
returns ever show up as data it will give invalid results.

The easiest method (in my opinion) is to use the Microsoft Text ODBC driver
instead.

Andrew Faust