Link to home
Start Free TrialLog in
Avatar of west_ham_66
west_ham_66

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Faizan Sarwar
Faizan Sarwar
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of west_ham_66
west_ham_66

ASKER

That worked a treat cheers