Chris Walcott wrote:
How do I LOAD a text file into a table that has a Primary Key defined?
I drop the Primary Key (and Timestamp) when I use 'load data infile'.
Below is my VB code which I use in Access to import stuff into MySQL.
Maybe someone will find it useful.
The point is that you h
I'd pick up the text file and search/replace all end of line character(s)
with a end of line"00 "comma combination so it reads
> 00,Abe,Lincoln,8347
on each line and try your first method. If that fails, I would drop the ID
field off the table, then do the import with original file, then atlter the