Unanswered: writing to MSAcess: Sql Error: General?
I am writing an app to parse a massive csv file and enter the data into a MSAccess database using jdbc.odbc. The csv file has about 7,000 lines but it gets to just over 5,000 lines entered into the database but then gives a sql error : general error.
Is there a limit to the amount of data you can push through odbc?
I haven't got the code on hand but will post it tomorrow, if it helps.