Thursday, September 24, 2009

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

4 Comments:

At 3:58 AM, Anonymous Tera Online said...

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

 
At 12:59 AM, Anonymous wow gold said...

Most of the particular Mmo currency Cheapest WOW Gold retail outlets will Purchasing Sidesplitter Aureate carry the percent from the RS your own previous(a) wristwatches, when your clench could possibly be huge, then you need to wait for an inadequate objet d'art (ordinarily more or less all day and in some cases numerous days) until such time as masses collect your current Gold WOW stock-taking for you Bribe Aion Kinah personally. You'll want to be affected person from time to time if they're offered-come out of the closet at that moment,Grease one's palms Tera Gilt it's very criterion internet Buying WOW Gold promotion purchased-emerge for you actually, simply because Old watches is successful victimization the majority of oceans.

 
At 10:59 PM, Blogger ambersbridal said...

A holy church, rings, a bouquet, a 3-floor wedding cake, lace wedding dress champagne, and the moving promise “ I do”, make up the happiest moment in one’s life. Then it is the wedding.
lace wedding gowns
A gorgeous wedding dress has been inside a girl’s dream since she was five years old. It is widely said that the bride is the most beautiful woman all over the world.
Bridal gowns vary in different parts of the world. For example, cheap wedding dresses plus sizein traditional Chinese culture, the color red is regarded for centuries as the symbol of good luck; while in the Occident, wedding dresses 2012 a full-length white wedding dress is always associated with romance and sanctity. But, with the globalization, wedding dresses tend to be alike in the whole world.

 
At 1:25 AM, Blogger Selfless said...

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