Take data from excel spreadsheet and insert into SQL SERVER database

Asked

Viewed 998 times

0

I want to know if you have how to take the records of a spreadsheet and play for an SQL-SERVER table, there is this possibility ?

sql sql-server excel

  • https://answall.com/questions/121767/importar-excel-para-sql-server-c

  • https://answall.com/search?q=%5Bsql-server%5D+excel

  • Good morning. So which version of your sql server, I use here sql server 2012 and have a program in it that already does this automatic import, as long as the table is created right in your database, the name of the program and Import and Export Data that is inside the Microsoft sql server folder.

  • your question has been answered here https://answall.com/a/30413/5846

  • Where this program is, I can’t even find it in the folder, I use sql server 2012 as well.

  • This program is on the machine where sql server is installed

  • Uses the sql server wizard "IMPORT AND EXPORT DATA" to impute your spreadsheet directly in the database

Show 2 more comments
No answers

Browser other questions tagged sql sql-server excel

You are not signed in. Login or sign up in order to post.