--On Friday, January 14, 2005 14:39 -0700 Steve Grosz <[EMAIL PROTECTED]> wrote:
I had tried to load a group of records from a Excel spreadsheet, and for the most part it seems to have worked.
The problem is that I know there were more than 1000 rows of data to be input, and it stopped at 1000 exactly.
Am I missing something to allow more than 1000 rows to be input?
Steve
This is extremely vague. How exactly are you loading the data, excel doesn't talk to MySQL directly, are you using MyODBC/ODBC drivers?
Are you exporting the excel to CSV then importing that, if so how? Did you notice any errors during the import process? What type of data is it, very large fields/columns? some distributions only allow a 1MB max packet size, which equates to BLOBs of no more than 1MB, and single row sizes of no more than 1MB, and depending on how oyu do the import can mean no mor ethan 1MB total data in a single batch.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
