At 11:29 -0500 3/12/03, Tamayo, Nelson wrote:
Is there a way to convert an Access database into MySQL easily?
I am running into problems trying to convert it through VB code using a
recordset. I'm rather new at this stuff. I'm also tried generating an insert
statement through VB code and then executing it, I get the error "Unknown
column 'False' in 'field list'"
this is the SQL string I am using to insert the record.
insert into csapps.qainfo
(DCN,NoRetention,AttachmentCode,NPPN,CPTList,ReceivedDate,Answered,ClientID,
PPO,Retry,Tax,EOP,TXDeficientIsAnswered,TXDeficient,CACPAnswered,CACPAuthori
zed,MGMAnswered,MGMContracted,Priority,ImageStatus,BatchCode)
values
('123673852',False,'E : JUST an ID CARD',False,
'Dental','8/19/2001',True,'TN','??',0,0,'TX',True,False,False,False,False,Fa
lse,1,'NotRequested','N1TN236012')
You're assuming that True and False are predefined values in MySQL,
which they aren't. Thus, MySQL sees these unquoted values and assumes
they are column names. Substitute appropriate literal values such as
1 and 0, or perhaps 'True' and 'False'.
Any ideas?
Nelson Tamayo
Claims Automation
(800) 237-7767 x3520
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
