Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 213
  • Last Modified:

Creating an SQL table using columns from Excel

Hi guys,

I am just wondering is it possible to create a new SQL table automatically using the column headers from an excel file?

I am currently attempting to do it using SSIS but cannot seem to find what I'm looking for.

Thanks
Peter
0
west_ham_66
Asked:
west_ham_66
1 Solution
 
sm394Commented:
Try

Right click database
Tasks..-> Import Data   Wizard
Select Datasource : Microsoft Excel
check First row has column names
0
 
west_ham_66Author Commented:
That worked a treat cheers
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now