A friend asked about how to import data from Excel to table in SQL, then I searched for it. Found this code. Having tried it, I think it's a nice idea to share it.
INSERT INTO Table_Name
SELECT column1, column2
FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\ExcelTable.xls', 'SELECT * FROM [Sheet1$]')
About Me
- Steven Luck
- Is an ordinary man, with a little knowledge to share and high dreams to achieve. I'd be glad if I can help others, 'coz the only thing for the triumph of evil is for a good man to do nothing.
Popular Posts
-
Have just got a lovely blog award, my second one, from a friend, Mona ^^ But there is a rule to accept this award.. hehehe... Post it on yo... -
Are you learning Assembly language , and confused about how to compile assembly file? TASM20 is one of assembly compilers that works with ... -
Error: Creation of the virtual directory http://localhost/web failed with error: Could not find the server 'http://localhost' on the... -
I'd like to share how to make a report using Crystal Report, and connect it from VB here, since there has been several friends asking ab... -
This is another blog award from a friend, a programmer too, Kampoeng-IT . Through this post, I would like to thank this friend for the award...
0 comments:
Post a Comment