如何使用C#将过滤的数据从Autodesk Revit导出到MS-Access？

using Autodesk.Revit.DB;
using System.Data.OleDb;

namespace RevitToAccessExporter
{
    class Program
    {
        static void Main(string[] args)
        {
            // 连接到Revit文档
            Document doc = GetRevitDocument();

            // 过滤需要导出的数据
            FilteredElementCollector collector = new FilteredElementCollector(doc);
            ICollection<Element> elements = collector.OfClass(typeof(FamilyInstance)).ToElements();

            // 连接到MS-Access数据库
            OleDbConnection connection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\path\\to\\database.accdb");
            connection.Open();

            // 创建一个新的表格或选择已存在的表格
            OleDbCommand createTableCommand = new OleDbCommand("CREATE TABLE IF NOT EXISTS Elements (Id INT, Name VARCHAR(255))", connection);
            createTableCommand.ExecuteNonQuery();

            // 将过滤后的数据逐条插入到MS-Access表格中
            foreach (Element element in elements)
            {
                int id = element.Id.IntegerValue;
                string name = element.Name;

                OleDbCommand insertCommand = new OleDbCommand("INSERT INTO Elements (Id, Name) VALUES (@Id, @Name)", connection);
                insertCommand.Parameters.AddWithValue("@Id", id);
                insertCommand.Parameters.AddWithValue("@Name", name);
                insertCommand.ExecuteNonQuery();
            }

            // 关闭数据库连接
            connection.Close();
        }

        static Document GetRevitDocument()
        {
            // 获取Revit文档的逻辑
            // ...
        }
    }
}