Excel file to SQL table

vbnetcoder
vbnetcoder used Ask the Experts™
on
What is the easiest way to insert the contents of and excel file into a sql table
?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010
Commented:
Via SSMS.  Import the Excel file using Tasks -> Import Data

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial