Question

I have an MS Access database file that I want to copy into a MySQL to serve up on a webpage, the problem is the database is passworded. What I want to do is upload the file to the server then either strip the password or open it using the password so I can then copy it across to MySQL. The password is known and cannot be removed at source. I would like to do this with PHP if possible.

这是一次经常性事件,每天最多两次。

在与我的东道方接触后,唯一使用货物的方式是提升到以10x美元的价格提供我目前的东道方。如果我能以另一种方式获得数据,那么就没有了。

Answer 1

<><>>>开放<><>>>>>>>> >,在座标上应沿途通过密码...... 对于使用二氯苯基苯基(脱硫)的PHP,可检索here。既然你说这些口号是众所周知的,这应当发挥作用。

为了完全消除这一障碍,你想在无障碍地打开大门,并在没有密码的情况下节省一份副本。我确信,这不会容易自动化。如果你需要查阅数据并反复加以转让,我就坚持他连接的密码。

Example from the article linked to:

<?php
// Microsoft SQL Server using the SQL Native Client 10.0 ODBC Driver - allows connection to SQL 7, 2000, 2005 and 2008
$connection = odbc_connect("Driver={SQL Server Native Client 10.0};Server=$server;Database=$database;", $user, $password);

// Microsoft Access
$connection = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=$mdbFilename", $user, $password);

// Microsoft Excel
$excelFile = realpath( C:/ExcelData.xls );
$excelDir = dirname($excelFile);
$connection = odbc_connect("Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=$excelFile;DefaultDir=$excelDir" ,   ,   );
?>

Answer 2

下面是《国际功能说明》的样本:

<?php
$db_connection = new COM("ADODB.Connection");

$db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("../databases/database.mdb") ." ;DefaultDir=". realpath("../databases");
$db_connection->open($db_connstr);
$rs = $db_connection->execute("SELECT * FROM Table");
$rs_fld0 = $rs->Fields(0);
$rs_fld1 = $rs->Fields(1);
while (!$rs->EOF) {
  print "$rs_fld0->value $rs_fld1->value
";
  $rs->MoveNext(); /* updates fields! */
}
$rs->Close();
$db_connection->Close();
?>

友情链接