{"height":"190","blog_url":"https://satob.hatenablog.com/","categories":["Excel","OLEDB","PowerShell"],"provider_url":"https://hatena.blog","blog_title":"Lazy Diary @ Hatena Blog","image_url":null,"type":"rich","author_url":"https://blog.hatena.ne.jp/satob/","author_name":"satob","published":"2021-11-25 01:28:35","width":"100%","description":"satob.hatenablog.com You can make an Excel file (.xlsx) without Excel by using Microsoft.ACE.OLEDB, but the behavior of INSERT is also a little bit weird. The behavior changes according to the CREATE TABLE is executed in the same connection, the suffix of the sheet name ($) in the INSERT statement, \u2026","title":"How to insert a new row with datatype constraints by using Microsoft.ACE.OLEDB","provider_name":"Hatena Blog","version":"1.0","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fsatob.hatenablog.com%2Fentry%2F2021%2F11%2F25%2F012835\" title=\"How to insert a new row with datatype constraints by using Microsoft.ACE.OLEDB - Lazy Diary @ Hatena Blog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","url":"https://satob.hatenablog.com/entry/2021/11/25/012835"}