0

I have an SQL database that contains a table with 5 rows (and 4 columns). I need to import a very long table (100+ rows, same number of columns) that I have created in Excel. Is there an easy, quick way to do this 'paste'-like operation?

jarlh
  • 42,561
  • 8
  • 45
  • 63
Dsto4
  • 103
  • 3
  • 10
  • What flavour of SQL database? – QHarr Apr 12 '18 at 08:13
  • Right, sorry. It's SQLite and I am using the open soure dBeaver to view/edit it. Thanks – Dsto4 Apr 12 '18 at 08:15
  • https://stackoverflow.com/questions/17439885/export-data-from-excel-to-sqlite-database?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa Seems there is .import statement – QHarr Apr 12 '18 at 08:18

1 Answers1

0

In SQL Server Managment

  1. Right Click on the DB Name in the solution explorer
  2. Select Tasks-> Import Data
  3. In the opened wizard choose 'Microsoft Excel' as data source
  4. Select the excel file path and the excel version
  5. Clisk next and choose the destination table details
  6. Finish
Stack Overflow
  • 2,416
  • 6
  • 23
  • 45