"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
[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
-
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 exec
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 'Fal
