Tool to convert Excel Columns to SQL Create Table

Is there a tool to easily convert Excel columns into SQL Create Table

Ex: I have col1,col2,col3 and want to

CREATE TABLE table_name
(
col1 data_type,
col2 data_type,
col3 data_type
)
pmsguyAsked:
Who is Participating?
 
Tone' ShelbyConnect With a Mentor Microsoft® Platform Business Intelligence & Power BI Developer / Data AnalystCommented:
There are about six ways to import data from Excel to and SQL Server Integration Services is my favorite Tool For Conversion of Excel & Visa Versa. You can take from pretty much any format into another...

Check out this support link from Microsoft that can guide you in the way you choose to move forward ...
Called: How to import data from Excel to SQL Server
http://support.microsoft.com/kb/321686
0
 
Patrick MatthewsCommented:
Hello pmsguy,

It would be useful to see some sample data.  EE now allows you to directly upload
files to your question.

Please be advised that once you upload a file, it can be publicly accessed, and that it
may not be possible to fully and permanently delete it.  Therefore, be very careful about
posting proprietary, confidential, or other sensitive information.  If necessary, use "fake"
and/or obfuscated data in your sample.

Regards,

Patrick
0
All Courses

From novice to tech pro — start learning today.