hi osc Fans
I got a mdb file.
I list all the articles store in that mdb like follows
<?php
$db_connection = new COM("ADODB.Connection");
$db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=".realpath("AbcPelado2000.mdb")." ;DefaultDir=". realpath("");
$db_connection->open($db_connstr);
$rs = $db_connection->execute("SELECT Descripcion FROM Articulos");
$rs_campo0 = $rs->Fields(0);
while (!$rs->EOF) {
echo 'Articulo: '.$rs_campo0->value.'<br>';
$rs->MoveNext();
}
$rs->Close();
$db_connection->Close();
echo '<br>Finished';
Well, now comes the difficult question:
Which SQL code does osc use for inserting a new product into the system?
I'd modify the above code so i can move the articles from mdb to osc
That mdb also has a categories table, but i'll be happy just to know how to insert the articles, then i create manually the categories and pass the whole day moving stuff...
thanks alot...




LinkBack URL
About LinkBacks






Bookmarks