pmsguy
asked on
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
)
Ex: I have col1,col2,col3 and want to
CREATE TABLE table_name
(
col1 data_type,
col2 data_type,
col3 data_type
)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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