Hello to all.
I want to load a file with values to a Table in MySql, and the code is something like this:

PHP Code:
if (returnVal == JFileChooser.APPROVE_OPTION) {
            File file = fc.getSelectedFile();
              log.append("Loading File: " + file.getName()+ "." + newline);
             Statement stmt = null;
                     conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/Database","user","password");
                     stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
                     stmt.executeUpdate("LOAD DATA INFILE \"" + file.toURI().getPath() + "\" INTO TABLE gastos (valordesp,datadespesa,tipo,idconta,titular)");

					catch(Exception e)
						stmt = null;

The error shows that there's no file in:

java.sql.SQLException: File 'C:\C:\Users\Consultor\Documents\Despesas.txt

That's because it appears 2 times C: so how can i overcome this, can anibody help?

Rui Oliveira