I am attempting to load data from a .txt file that is csv formatted into a MS Access Database. I tried doing this with the INSERT statemetnt with success, but the processing is very slow. When searching on how to speed it up, it was suggested that using LOAD DATA INFILE was much quicker. When attempting to do this I receive an error of an invalid SQL statement. Here is my code and error message:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(Unknown Source)
Thanks in advanced for any insight as to what might be wrong.
Joined: Sep 06, 2011
Nm...I found out this won't work with MS Access. That is the issue.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com