SQL Server select data from CSV as if it were a table
I can select without using DTS or a linked server.
SELECT * FROM OPENROWSET
('MICROSOFT.JET.OLEDB.4.0','Text;Database=C:\Folder\;',
'SELECT * FROM [Report.csv]') MyAlias
You may need these permissions
sp_configure 'Ad Hoc Distributed Queries', 1
reconfigure
You may have problems on X64
posted by dwight0 @ 1:13 PM
2 comments
2 Comments:
Thank you for this blog. That’s all I can say. You most definitely have made this blog into something that’s eye opening and important.
Here useful link:Tera Gold Cheap Tera Items
Epic did not stop with the comet landing. The brand new superhero motif is also an innovative means to create yet another layer onto the continuing narrative and fortnite cheap weapons give players more ways to express themselves. There are new costumes to unlock and goofy emotes, one culled out of a popular online meme. However, this season, Epic included two superhero skins that can only be upgraded by playing the game, performing struggles, and leveling up using in-game experience points. You can't purchase your way to these upgrades; you have to make them exactly like in any hardcore role-playing game. The substantial upgrade paths, unlockable rewards, along with also the persistent but ever-changing game map make Fortnite a considerably meatier encounter than Playerunknown's Battlegrounds, that has static, fortnite items for sale unchanging surroundings and otherwise dull customization choices.
Post a Comment
<< Home