I'm trying to load a SQL database using Microsoft SQL Server Management. I have all the tables made and have a large number of items to enter into it. I'm pretty sure there is a way to Take an EXCEL File and copy all of one row or columns and then insert it into a table? I have tried goggling this and looking it up online. But I'm afraid I'm not entering the right words or phrases in to bring up what I need. Does anyone know how to do this or a good website that has detail walkthrough on how to do this??? Please HELP!
Hi, This is something I did a lot in the past and SQL Server has been able to do this for the past few versions. On this page: http://iis7test.com/webcasts/ Webcast #2 I show how to get data from Excel into SQL Server, and how to correct anymistakes Excel may have made. The newer versions of Excel don't always deliminate properly but it's easy to correct in SQL Server. Salute, Mark
