March 27, 2015 at 3:40 am
hello , i need advice on whether it is possible to copy a table from MS excel into SQL server Table ? Thank you
March 27, 2015 at 3:44 am
Yes, you can use SSIS, bcp or BULK INSERT, whichever works best for you. There are other cruder ways of doing it as well, such as building a set of INSERT statements in your spreadsheets and executing them in SSMS.
John
March 27, 2015 at 3:49 am
I would ask some tutorial? thank you
March 27, 2015 at 7:33 am
You can also just import the Excel file directly into a new table.
Right click on DB, Tasks, Import Data and select the Excel file as your source.
March 30, 2015 at 5:48 am
How many records? I find that right clicking on an empty table and selecting edit top 200 rows. From there, you can past the contents of the excel file.
Have a great Monday!
March 31, 2015 at 1:21 am
hi , import data go only open XML ? because odb table . I do not want to open. Thank you
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply