How to Bulk Insert from XLSX file extension?

by

you can save the xlsx file as a tab-delimited text file and do 

BULK INSERT TableName
        FROM 'C:\SomeDirectory\my table.txt'
            WITH
    (
                FIELDTERMINATOR = '\t',
                ROWTERMINATOR = '\n'
    )
GO

More Related Contents:

  1. Bulk Insert Partially Quoted CSV File in SQL Server
  2. SQL Server Bulk insert of CSV file with inconsistent quotes
  3. How to write UTF-8 characters using bulk insert in SQL Server?
  4. BULK INSERT with identity (auto-increment) column
  5. Bulk insert with text qualifier in SQL Server
  6. Cannot bulk load. Operating system error code 5 (Access is denied.)
  7. How do I use cascade delete with SQL Server?
  8. An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON SQL Server
  9. Maximum size of a varchar(max) variable
  10. Why do table names in SQL Server start with “dbo”?
  11. Add alternating row color to SQL Server Reporting services report
  12. How Do I Split a Delimited String in SQL Server Without Creating a Function?
  13. What’s the longest possible worldwide phone number I should consider in SQL varchar(length) for phone
  14. How to enable bulk permission in SQL Server
  15. Should every User Table have a Clustered Index?
  16. How to load an XML file into a database using an SSIS package?
  17. Aggregate bitwise-OR in a subquery
  18. How to connect to MS SQL Server using Inno Setup?
  19. Check if a temporary table exists and delete if it exists before creating a temporary table
  20. SQL count rows in a table
  21. How do I programmatically set the connection string for Entity-Framework Code-First?
  22. Executing set of SQL queries using batch file?
  23. T-SQL incrementing counter based on change in a column value
  24. How can I fill a column with random numbers in SQL? I get the same value in every row
  25. The request failed or the service did not respond in a timely fashion?
  26. Joining tables from different servers
  27. Change type of a column with numbers from varchar to int
  28. Get row where datetime column = today
  29. ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException
  30. SQL Server – How to insert a record and make sure it is unique

Leave a Comment