Re: Converting DBs

2003-03-12 Thread Paul DuBois
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

Re: Converting DBs

2003-03-12 Thread dpgirago
[filter fodder = sql,query,queries,smallint ] you haven't indicated what the column attributes are, but you might try putting quotes around the TRUE and FALSE values ( assuming they are being inserted into char or varchar columns). David

Re: Converting DBs

2003-03-12 Thread walt
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