Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Location
    Brisbane, QLD Australia
    Posts
    2

    Red face 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.

    Is there a free jdbc connector for MSAccess?

    Thanks in Advance!

  2. #2
    Join Date
    Jun 2003
    Location
    Brisbane, QLD Australia
    Posts
    2

    Lightbulb Update

    I have fixed general sql error (Damn ' special characters!)

    but I am still disappointed with the speed of importing the data into Access.

    Does anyone know of a free driver that does this quicker than the stock microsoft one?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •