Menu
Is there an easy way to create a table in SQL Server (2005) from an Excel spreadsheet. I'm thinking maybe some tool?
Thanks in advance.
417
Click a cell within your data range. Press CTRL + T (hold down the CTRL-key and press T) The Create Table dialog will be shown: Click OK and your data will now be in an Excel table.
First, copy the data from Excel, and then paste it into the SQL Server table using the Database > Table > Edit top 200 rows menu option. Always start by copying and pasting a single row of data to validate the data types.
Open an SQL connection to an Excel file Before running an SQL query, you have to open a connection with the Excel file you want to access. To establish the connection, create a new variable named %Excel_File_Path% and initialize it with the Excel file path.
You can use an Excel AddIn such as SQL Spreads (www.sqlspreads.com) to let your end users push the data directly from Excel to SQL Server. It can also handle different number of rows.
SQL Server 2008R2+
56
Save excel file as text(unicode) file and then use "sql import and export data" from all programs then select "flat file source" as file source and browse the txt file.Thats it.Simple and clear.
45
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
