List:General Discussion« Previous MessageNext Message »
From:Chris Knipe Date:May 14 2003 8:57pm
Subject:Re: major access2mysql issues
View as plain text  
> > timecode_in , locations) VALUES ('New Year Wrap' , 2 , '1996-01-01' ,
> > 21 , 'L96' , 1 , , 1 , '1996-01-05 16:40:00' , 6 , 2 , '00:1:39' , '' ,
^^^^^^^^^^^^^^^^^^^^

'L96', 1, NULL, '1996....

or alternatively,

'L96', 1, '', 1996...

Not tested, but that should be your problem... Look, you did add the , '',
for the null value at the end of that line, so maybe you just made a slight
typo there :)

--
me


Thread
major access2mysql issues(Daniel Rossi)11 May
  • Re: major access2mysql issues(Terry Riley)14 May
    • Re: major access2mysql issuesChris Knipe14 May
  • Re: major access2mysql issuesDaniel Kasak23 May
RE: major access2mysql issuesMike Hillyer12 May