Generate sql insert script from excel worksheet

by

I think importing using one of the methods mentioned is ideal if it truly is a large file, but you can use Excel to create insert statements:

="INSERT INTO table_name VALUES('"&A1&"','"&B1&"','"&C1&"')"

In MS SQL you can use:

SET NOCOUNT ON

To forego showing all the ‘1 row affected’ comments. And if you are doing a lot of rows and it errors out, put a GO between statements every once in a while

More Related Contents:

  1. SQL Query output in VBA is different than in SQL Oracle
  2. Can anyone help me with this SQL Query?
  3. Performing SQL queries on an Excel Table within a Workbook with VBA Macro
  4. How to run a SQL query on an Excel table?
  5. Using Excel VBA to export data to MS Access table
  6. Export SQL query data to Excel
  7. Accessing SQL Database in Excel-VBA
  8. Excel function to make SQL-like queries on worksheet data?
  9. how to pass parameters to query in SQL (Excel)
  10. Using Excel VBA to run SQL query
  11. How do I call an Oracle stored procedure from an Excel VBA script?
  12. Convert from string to datatime in sql [duplicate]
  13. A simple subquery in SQL
  14. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  15. Why does NULL = NULL evaluate to false in SQL server
  16. SQL to LINQ with multiple join, count and left join
  17. How do I make a row generator in MySQL?
  18. Oracle “(+)” Operator
  19. Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures? [closed]
  20. GROUP BY and aggregate sequential numeric values
  21. Safely rename tables using serial primary key columns
  22. How to pass variable as a parameter in Execute SQL Task SSIS?
  23. Postgres manually alter sequence
  24. Query runs slow with date expression, but fast with string literal
  25. Should I use SQL_Variant data type?
  26. Oracle insert if row does not exist
  27. Getting the Id of a row I updated in Sql Server
  28. SQL: Select rows with a column value that occurs at least N times?
  29. Historical / auditable database
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment