How to Upload CSV file into Ms-Access Database table

You did not answer any of my questions. It's helpful to know precisely where a poster is coming from - how much help they need - what they already know. Too often OPs either get irritated because others trying to help guess wrongly and either tell/show the poster things they already know, or because they don't give the OP enough information, the OP gets frustrated.

abillconsla at 2007-7-12 2:00:25 >

> I heard If i Use CSV it will be easier to read students record into the Database table.

You still haven't stated what your problem is!!!

In order to use a CSV file you need to know how to read a line of text from a file. Do you know how to do this? If so, where is your posted code showing how you do this.

Then once you have a line of text, you need to parse the text into individual tokens. Do you know how to do this? Did you search the forum for examples of how to do this, since there are many examples posted.

Finally once you have individual tokens you can create an SQL statement to insert the data into the database. Do you know how to do this?

You need to learn how to break a problem down into individual steps and state which step you are having a problem with.

> Could you please give a Sample code to import CSV File into Database

We are not going to write the code for you and that statement does not tell us what you are having a problem with.

camickra at 2007-7-12 2:00:25 >

Hi

I Learned how to read a file text and Parse as StringTokenizer. But still i don't know how to read the Individual tokens into to database.

But now i face a new Problem, i am not able to sort it out.

i am posting my code

import java.io.FileReader;

import java.io.FileWriter;

import java.io.BufferedReader;

import java.io.PrintWriter;

import java.io.IOException;

import java.io.*;

import java.util.*;

public class CSVExample {

public static void main(String[] args) throws IOException {

BufferedReader inputStream = null;

PrintWriter outputStream = null;

try {

inputStream = new BufferedReader(new FileReader("file.csv"));

String text;

while((text=inputStream.readLine())!= null)

{

StringTokenizer st = new StringTokenizer(text);

if(st.hasMoreTokens())

{

System.out.println(st.nextToken());

}

}

} finally {

if (inputStream != null) {

inputStream.close();

}

}

}

}

Here the Problem is The file.csv has got two fields ID, NAME The content of this file is as follows

T12,MR.RAJ KUMAR

T13,MR.EARNEST DIES

T14,MR.MATHEW HYDEN

Now when i StringTokenize this File The Output printed as follows

T12,MR.RAJ

T13,MR.EARNEST

T14,MR.MATHEW

That means when it finds the Space it is not printing the Remaining Text.

Please Help me in this and then Tell me how to INSER The Tokens into the Database Table

Thank you for your service

Cheers

Jofin

jofin123a at 2007-7-12 2:00:26 >

Hi abillconsl

I am not that much Experienced java programer. just now i am trying to Learn. What you posted will be Usefull I think. Because after seeing the Scanner in your Posted only. I started to Learn about it. More over if you give Little bit elaborately, I think it will be More Helpful, Since i am a Beginner.

Could you please give state any Command or Give some help on the Previouse Post what i have tried According to Mr.camickr's Suggestion, But still I don't know how to use the Tonkens into the SQL statement to insert into the Database table.

Please help me to Learn the things and implement them

Thank you for your service

Cheers

jofin

jofin123a at 2007-7-12 2:00:26 >

> Hi

>

> I Learned how to read a file text and Parse

> as StringTokenizer. But still i don't know how to

> read the Individual tokens into to database.

>

> But now i face a new Problem, i am not able to sort

> it out.

>

> i am posting my code

Try this code - note the commented out and replaced code - it should do what you want.

import java.io.FileReader;

import java.io.FileWriter;

import java.io.BufferedReader;

import java.io.PrintWriter;

import java.io.IOException;

import java.io.*;

import java.util.*;

public class CSVExample {

public static void main(String[] args) throws IOException {

BufferedReader inputStream = null;

PrintWriter outputStream = null;

try {

inputStream = new BufferedReader(new FileReader("file.csv"));

String text;

String[] tokens;

while((text=inputStream.readLine())!= null)

{

// StringTokenizer st = new StringTokenizer(text);

tokens = text.split(",");

//if(st.hasMoreTokens())

for (int i = 0l i < tokens.length;i++)

{

System.out.println(tokens[i]);

}

}

} finally {

if (inputStream != null) {

inputStream.close();

}

}

}

}

Message was edited by:

abillconsl

abillconsla at 2007-7-12 2:00:26 >

Hi

I tried to that with your suggestion now i am getting a Error During the Run time.

My Code is This

import java.io.FileReader;

import java.io.FileWriter;

import java.io.BufferedReader;

import java.io.PrintWriter;

import java.io.IOException;

import java.io.*;

import java.util.*;

import java.sql.*;

public class CSVExample {

public static void main(String[] args) throws IOException {

BufferedReader inputStream = null;

PrintWriter outputStream = null;

Connection con=null;

ResultSet rs;

Statement st;

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

con=DriverManager.getConnection("jdbc:odbc:Library");

System.out.println("Connected");

}

catch(ClassNotFoundException ex)

{

ex.printStackTrace();

}

catch(SQLException e)

{

e.printStackTrace();

}

try {

inputStream = new BufferedReader(new FileReader("file.csv"));

String text;

while(true)

{

text = inputStream.readLine();

if(text==null)

{

break;

}

StringTokenizer token =new StringTokenizer(text,",");

System.out.println("LOOP BROKEN");

while(token.hasMoreTokens())

{

try

{

String id=token.nextToken();

String name =token.nextToken();

String age=token.nextToken();

//String count=token.nextToken();

//String cat=token.nextToken();

//System.out.println();

// SQL to insert the Tokens into the Database Table

String sql="INSERT INTO Member(ID,Name,Age)VALUES(?,?,?)";

PreparedStatement pstm=con.prepareStatement(sql);

pstm.setString(1,id);

pstm.setString(2,name);

pstm.setString(3,age);

pstm.executeUpdate();

pstm.close();

}

catch(SQLException ex)

{

ex.printStackTrace();

}

}

}

} finally {

if (inputStream != null) {

inputStream.close();

}

}

}

}

I think there Error is in this String id=token.nextToken();

String name =token.nextToken();

String age=token.nextToken();

Place only. But i am not able to Findout out what would be the Reason to get the Error.

The Acuall Error is this Exception in thread "main" java.util.NoSuchElementException

Please provide me a Solution to come out of this Problem

Thank you for your service

Cheers

Jofin

jofin123a at 2007-7-21 20:19:56 >

Did you read the API to find out how the nextToken() method works. Thats what the API is for. It will explain why the exception is thrown.

> The file.csv has got two fields ID, NAME

Well then why are you trying to access "THREE" tokens?

> String id=token.nextToken();

> String name =token.nextToken();

> String age=token.nextToken();

camickra at 2007-7-21 20:19:56 >

Two things:

1) This line: for(int i=0;i<5;i++)

Should be:

for(int i=0;i<str.length;i++)

2) Don't like the way you spelled COMPLETETE(SIC)

~Bill>

abillconsla at 2007-7-21 20:19:56 >

Hi

I tried to convert the String into Integer by using Integer.parseInt()

method.

But when i execute the PreparedStatement i am getting General Error

I post the Code only where i am doing the Convertion

Please help me out

pstm = conn.prepareStatement("insert into Members (RollNumber,Name,Mstart,Bcnt,Mcat)values(?,?,?,?,?)");

System.out.println("This this the DATABASE CONNECTION:"+conn);

String result;

System.out.println("YES I AM CALLED FOR HELP");

String FilePath=txtLocation.getText();

inputStream = new BufferedReader(new FileReader(FilePath));

while((result=inputStream.readLine())!=null)

{

StringTokenizer stk = new StringTokenizer(result,",");

String studentid=stk.nextToken();

pstm.setString(1,studentid);

String studentname =stk.nextToken();

pstm.setString(2,studentname);

String entrydate=stk.nextToken();

pstm.setString(3,entrydate);

int bcount =Integer.parseInt(stk.nextToken());

pstm.setInt(4,bcount);

int cate =Integer.parseInt(stk.nextToken());

pstm.setInt(5,cate);

pstm.executeUpdate();

}

It gives this general Error in this line pstm.executeUpdate

Please tell me what would be the Problem here.

Thank you for you help

Cheers

Jofin

jofin123a at 2007-7-21 20:19:56 >