import data from CSV

  • Thread starter Thread starter a
  • Start date Start date
A

a

Dear friends

I want import data from CSV file to mdb file How can I do that in vb.net?
 
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.
 
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
 
Family Tree Mike said:
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.
Click to expand...

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import data from csv file 9
Which is the best MBOX Converter Tool different formats conversion? 4
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
What is SQl Command needed??? 1
imports succeed, but can't find data 0
Problem with access acImportDelim importing csv with headers 1
Access Importing csv daily files into access 2007 1
Multiple OU's in csvde 0

Back
Top