Wednesday, January 22, 2014

Insert Data Into Excel Sql Server 2008

INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0';'Database=@myfile';,'SELECT *  FROM [@SheetName]')

No comments:

Post a Comment

📱Build WhatsApp Bot using .NET + OpenAI

   In this article, you will learn how to build a real-world WhatsApp chatbot using ASP.NET Core and OpenAI. This bot can automatically repl...