{"provider_url":"https://hatena.blog","url":"https://ray88.hatenablog.com/entry/2020/12/04/230249","categories":[],"published":"2020-12-04 23:02:49","image_url":null,"author_url":"https://blog.hatena.ne.jp/ray88/","height":"190","version":"1.0","author_name":"ray88","width":"100%","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fray88.hatenablog.com%2Fentry%2F2020%2F12%2F04%2F230249\" title=\"\u30b5\u30fc\u30d0\u30c6\u30fc\u30d6\u30eb\u306e\u30c7\u30fc\u30bf\u3092\u30ed\u30fc\u30ab\u30eb\u30c6\u30fc\u30d6\u30eb\u3078\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b(\u90e8\u54c1\uff09 - ray88\u2019s diary\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","title":"\u30b5\u30fc\u30d0\u30c6\u30fc\u30d6\u30eb\u306e\u30c7\u30fc\u30bf\u3092\u30ed\u30fc\u30ab\u30eb\u30c6\u30fc\u30d6\u30eb\u3078\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b(\u90e8\u54c1\uff09","blog_url":"https://ray88.hatenablog.com/","type":"rich","provider_name":"Hatena Blog","description":"\u203b\u30da\u30fc\u30b8\u306e\u4e00\u756a\u4e0b\u306b\u3088\u308a\u52b9\u7387\u3088\u3044\u30b3\u30fc\u30c9\u306b\u5909\u66f4\u3057\u305f\u90e8\u54c1\u6539\u4fee\u7248\u3042\u308a \u25a0\u547c\u3073\u51fa\u3057\u5143\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3 Sub \u8aad\u8fbc\u30c6\u30b9\u30c8() Dim strResult As String strResult = fncImportTable(\"MT_\u793e\u54e1\u30de\u30b9\u30bf\", \"W_\u793e\u54e1\u30de\u30b9\u30bf\", 4) Debug.Print strResult End Sub \u25a0\u547c\u3073\u51fa\u3057\u5148 \u90e8\u54c1\u4f7f\u7528\u306e\u524d\u63d0\u6761\u4ef6\uff1a\u30d1\u30d6\u30ea\u30c3\u30af\u5b9a\u6570\u300cDbConnectionString\u300d\u306bDB\u30d5\u30a1\u30a4\u30eb\u306eADO\u63a5\u7d9a\u306eConnectionString\u3092\u8a2d\u5b9a\u3057\u3066\u304a\u304f \uff08\u4f8b\uff09\"Provider=Microsoft.ACE.OLEDB.12.0;\" & _ \"Data Sourc\u2026","blog_title":"ray88\u2019s diary"}