SQL server management studio importing

Question

Hi All

I am trying to import data from excel into my database tables in SQL Server management studio and the import facility just doesn't appear to be available. Could this be a permissions or setup issue? Apologies if I am posting in wrong area as I am new to this 

Answer 1

Welcome, this is the wrong forum, so moving where you may get better redirection.

Answer 2

thank you 

Answer 3

Hi Stuart,

The SQL forums are here:

https://social.technet.microsoft.com/Forums/en-us/home?category=sqlserver&filter=alltypes&sort=lastpostdesc

---

Don't retire TechNet! - (Don't give up yet - 13,225+ strong and growing)

Answer 4

I am trying to import data from excel into my database tables in SQL Server management studio and the import facility just doesn't appear to be available. Could this be a permissions or setup issue? Apologies if I am posting in wrong area as I am new to this 

Excel data can be imported to SQL easily by using SQL Server Import and Export Wizard which is available in SQL Server management Studio itself.

Right click on Database then select Task then Import data. Wizard opens up and just follow the instructions.

Please feel free to revert in case if you need additional details.

---

Cheers,
Vaibhav Chaudhari
MCP, MCTS, MCSA (SQL Server 2012)

Answer 5

Thank you, but unfortunately tasks do not appear in this menu on mine. I am not sure if this could have been locked down by the creator. Do you know if there is a way of turn on this 'task' function?

Thanks