Bom dia galere !
Seguinte, to fazendo um programinha qe pega os dados escolhidos do banco local e os insere em um banco do Access (Sim, TEM que ser o access 
)
Mais na hora de inserir os dados na tabela do access tá dando erro. Segue o código e o erro.
public void TransferirDados(){
try {
//Conectar ao Diamante
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:Diamante_hidro","","");
stm = conn.createStatement();
//Conectar ao Access
DBQ="C:/Banco1.mdb";
url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+DBQ;
usuario = "";
senha = "";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn1 = DriverManager.getConnection(url,usuario,senha);
//Consulta SQL
ResultSet rs = stm.executeQuery("SELECT * FROM Chuvas WHERE EstacaoCodigo=00469000");
while (rs.next()) {
stm1 = conn1.prepareStatement("INSERT INTO Chuvas (RegistroID,Importado,Temporario,Removido,ImportadoRepetido,"
+ "EstacaoCodigo,NivelConsistencia,Data,TipoMedicaoChuvas,Maxima,Total,DiaMaxima,NumDiasDeChuva,MaximaStatus,"
+ "TotalStatus,NumDiasDeChuvaStatus,TotalAnual,TotalAnualStatus,Chuva01,Chuva02,Chuva03,Chuva04,"
+ "Chuva05,Chuva06,Chuva07,Chuva08,Chuva09,Chuva10,Chuva11,Chuva12,Chuva13,Chuva14,Chuva15,Chuva16,Chuva17,"
+ "Chuva18,Chuva19,Chuva20,Chuva21,Chuva22,Chuva23,Chuva24,Chuva25,Chuva26,Chuva27,Chuva28,Chuva29,Chuva30,"
+ "Chuva31,Chuva01Status,Chuva02Status,Chuva03Status,Chuva04Status,Chuva05Status,Chuva06Status,Chuva07Status,"
+ "Chuva08Status,Chuva09Status,Chuva10Status,Chuva11Status,Chuva12Status,Chuva13Status,Chuva14Status,"
+ "Chuva15Status,Chuva16Status,Chuva17Status,Chuva18Status,Chuva19Status,Chuva20Status,Chuva21Status,"
+ "Chuva22Status,Chuva23Status,Chuva24Status,Chuva25Status,Chuva26Status,Chuva27Status,Chuva28Status,"
+ "Chuva29Status,Chuva30Status,Chuva31Status,DataIns,DataAlt,RespAlt)"
+ " VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
stm1.setDouble(1, rs.getDouble("RegistroID"));
stm1.setInt(2, rs.getInt("Importado"));
stm1.setInt(3, rs.getInt("Temporario"));
stm1.setInt(4, rs.getInt("Removido"));
stm1.setInt(5, rs.getInt("ImportadoRepetido"));
stm1.setInt(6, rs.getInt("EstacaoCodigo"));
stm1.setInt(7, rs.getInt("NivelConsistencia"));
stm1.setDate(8, rs.getDate("Data"));
stm1.setInt(9, rs.getInt("TipoMedicaoChuvas"));
stm1.setInt(10, rs.getInt("Maxima"));
stm1.setInt(11, rs.getInt("Total"));
stm1.setInt(12, rs.getInt("DiaMaxima"));
stm1.setInt(13, rs.getInt("NumDiasDeChuva"));
stm1.setInt(14, rs.getInt("MaximaStatus"));
stm1.setInt(15, rs.getInt("TotalStatus"));
stm1.setInt(16, rs.getInt("NumDiasDeChuvaStatus"));
stm1.setInt(17, rs.getInt("TotalAnual"));
stm1.setInt(18, rs.getInt("TotalAnualStatus"));
stm1.setInt(19, rs.getInt("Chuva01"));
stm1.setInt(20, rs.getInt("Chuva02"));
stm1.setInt(21, rs.getInt("Chuva03"));
stm1.setInt(22, rs.getInt("Chuva04"));
stm1.setInt(23, rs.getInt("Chuva05"));
stm1.setInt(24, rs.getInt("Chuva06"));
stm1.setInt(25, rs.getInt("Chuva07"));
stm1.setInt(26, rs.getInt("Chuva08"));
stm1.setInt(27, rs.getInt("Chuva09"));
stm1.setInt(28, rs.getInt("Chuva10"));
stm1.setInt(29, rs.getInt("Chuva11"));
stm1.setInt(30, rs.getInt("Chuva12"));
stm1.setInt(31, rs.getInt("Chuva13"));
stm1.setInt(32, rs.getInt("Chuva14"));
stm1.setInt(33, rs.getInt("Chuva15"));
stm1.setInt(34, rs.getInt("Chuva16"));
stm1.setInt(35, rs.getInt("Chuva17"));
stm1.setInt(36, rs.getInt("Chuva18"));
stm1.setInt(37, rs.getInt("Chuva19"));
stm1.setInt(38, rs.getInt("Chuva20"));
stm1.setInt(39, rs.getInt("Chuva21"));
stm1.setInt(40, rs.getInt("Chuva22"));
stm1.setInt(41, rs.getInt("Chuva23"));
stm1.setInt(42, rs.getInt("Chuva24"));
stm1.setInt(43, rs.getInt("Chuva25"));
stm1.setInt(44, rs.getInt("Chuva26"));
stm1.setInt(45, rs.getInt("Chuva27"));
stm1.setInt(46, rs.getInt("Chuva28"));
stm1.setInt(47, rs.getInt("Chuva29"));
stm1.setInt(48, rs.getInt("Chuva30"));
stm1.setInt(49, rs.getInt("Chuva31"));
stm1.setInt(50, rs.getInt("ChuvaStatus01"));
stm1.setInt(51, rs.getInt("ChuvaStatus02"));
stm1.setInt(52, rs.getInt("ChuvaStatus03"));
stm1.setInt(53, rs.getInt("ChuvaStatus04"));
stm1.setInt(54, rs.getInt("ChuvaStatus05"));
stm1.setInt(55, rs.getInt("ChuvaStatus06"));
stm1.setInt(56, rs.getInt("ChuvaStatus07"));
stm1.setInt(57, rs.getInt("ChuvaStatus08"));
stm1.setInt(58, rs.getInt("ChuvaStatus09"));
stm1.setInt(59, rs.getInt("ChuvaStatus10"));
stm1.setInt(60, rs.getInt("ChuvaStatus11"));
stm1.setInt(61, rs.getInt("ChuvaStatus12"));
stm1.setInt(62, rs.getInt("ChuvaStatus13"));
stm1.setInt(63, rs.getInt("ChuvaStatus14"));
stm1.setInt(64, rs.getInt("ChuvaStatus15"));
stm1.setInt(65, rs.getInt("ChuvaStatus16"));
stm1.setInt(66, rs.getInt("ChuvaStatus17"));
stm1.setInt(67, rs.getInt("ChuvaStatus18"));
stm1.setInt(68, rs.getInt("ChuvaStatus19"));
stm1.setInt(69, rs.getInt("ChuvaStatus20"));
stm1.setInt(70, rs.getInt("ChuvaStatus21"));
stm1.setInt(71, rs.getInt("ChuvaStatus22"));
stm1.setInt(72, rs.getInt("ChuvaStatus23"));
stm1.setInt(73, rs.getInt("ChuvaStatus24"));
stm1.setInt(74, rs.getInt("ChuvaStatus25"));
stm1.setInt(75, rs.getInt("ChuvaStatus26"));
stm1.setInt(76, rs.getInt("ChuvaStatus27"));
stm1.setInt(77, rs.getInt("ChuvaStatus28"));
stm1.setInt(78, rs.getInt("ChuvaStatus29"));
stm1.setInt(79, rs.getInt("ChuvaStatus30"));
stm1.setInt(80, rs.getInt("ChuvaStatus31"));
stm1.setDate(81, rs.getDate("DataIns"));
stm1.setDate(82, rs.getDate("DataAlt"));
stm1.setInt(83, rs.getInt("RespAlt"));
stm1.execute();
}
}catch(SQLException e){
e.printStackTrace();
}catch(NullPointerException e){
e.printStackTrace();
}catch(ClassNotFoundException e){
e.printStackTrace();
}
}
java.sql.SQLException: Column not found
at sun.jdbc.odbc.JdbcOdbcResultSet.findColumn(JdbcOdbcResultSet.java:1850)
at sun.jdbc.odbc.JdbcOdbcResultSet.getInt(JdbcOdbcResultSet.java:601)
at backupgenerator.TabelaChuva.TransferirDados(TabelaChuva.java:184)
....
Como vcs podem ver a tabela tem OITEEENTA E TRES campos e eu já to cansado de revisar esses campos pra ver se não tem algum errado.
E a essa altura eu já posso dizer qe tenho certeza qe não tem nenhum errado.
Então quem puder me dar uma ajuda com o erro, agredeço desde já !
Se tiver como eu saber pelo menos QUAL COLUNA ele tá acusando de não existir por favor me digam como. :oops:
Vlw !!
