Hi.
On Thu, Sep 27, 2001 at 11:59:26AM -0400, jord@stripped wrote:
>
> Hi,
> I have a csv txt file ton insert into a mysql table.
> I have inserted it loads of times and each time it says it has done it
> without error, but only about 30 of the 50 lines are actually inserted?!
>
> The csv came from access :-( But I don't understand why it fails without
> error.
>
> Any ideas please?
Example data would have been nice. It's difficult to say what's wrong
without having anything seen. I assume you use LOAD DATA.
Are you sure you have set the delimiters correctly?
I would try and find the first line in the CSV file which did not got
inserted and have a look if there is anything special about it.
Alternatively create a CSV file from the table and have a look at the
differences. May this helps.
Bye,
Benjamin.
PS: Removed cross posting to other mailing list.
--
benjamin-mysql@stripped
