如何使用脚本从访问数据库中删除行？ [英] How do I delete rows from an access database using a script?

问题描述

我正在尝试使用脚本（例如vbscript或whs）以编程方式从Microsoft Access数据库中删除行。

I am trying to programmatically remove rows from a Microsoft Access Database using a script (such as vbscript or whs).

似乎有两个或多个引擎可以用来连接到ADO扩展名Jro.JetEngine或DAO.Database DBEngine的mdb文件。

It looks like there are two or more engines that can be used to connect to an mdb file which are the ADO extension Jro.JetEngine or DAO.Database DBEngine.

此外，

我计划使用此表删除早于N天的条目。

I plan to use this to remove entries that are older than N days old.

我将如何实现这样的目标？

How would I achieve something like this?

推荐答案

您需要类似此脚本的内容。

You need something like this script.

connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & yourDatabase & ";"
sql = "delete from yourTable where CreateDate < " & yourDateString
set cn = createobject("ADODB.Connection")
set cmd = createobject("ADODB.Command")
cn.open connectionString
cmd.ActiveConnection = cn
cmd.CommandText = sql
cmd.execute
cn.Close

您可以在 connectionstrings.com

这篇关于如何使用脚本从访问数据库中删除行？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！