![]() ![]() However, I'm not into Powershell so if you prefer this method you will have to investigate a bit more.Īlso, this is a bit outdated but interesting read. You can use Excel-only solution and import data using Data pane in the Excel itself (Import from SQL server).Īnother possibility taht doesn't have to be coupled to SQL Server or Excel itself is Powershell. From Management Studio-> Object Explorer->ServerObjects->Right click Linked Servers to open a new Linked Server window. (Note: you can download the Excel files and code here) Next, create a new Linked Server pointing to Mytable.xls that was just created. ![]() If you need TSQL solution, OPENROWSET which you are mentioning in the question should be fine. First create an Excel file named MyTable.xls. That won't help you if you need programmatic solution, in which case you have to use Microsoft () or 3rd party solutions you can even build one using Office Open XML. now open your CSV file using Excel if appropriate save it in Excel as a native Excel format.select your folder/filename and ensure CSV type is selected below.right click the Results pane and select "Save Results As.".If you're looking for a quick and dirty solution, you can use Management Studio itself. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |