<div>
I am using the wizard.. but the table that I want to use is not coming up source tables.. its almost like it is making its own tables. How can I edit mapping on that? <a href="https://filedb.experts-exchange.com/incoming/2011/09_w39/501317/crystal1.jpg" target="_blank" title="mapping ?? (57 KB)"><img alt="mapping ??" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2011/09_w39/800_501317/crystal1.jpg" /></a>
</div>


I am using the wizard.. but the table that I want to use is not coming up source tables.. its almost like it is making its own tables. How can I edit mapping on that? mapping ??https://filedb.experts-exchange.com/incoming/2011/09_w39/501317/crystal1.jpg

crystal1.jpg

<div>
I figured it out.. thanks you too!
</div>


<div>
<div class="content wysiwyg-content">
This is probably pretty simple.. but I am drawing a blank. I went ahead and created a table that matches the fields in the Excel file. This reason I did this is that many of the field name in the Excel file were name very strangly. for example DQM# or Contact ID #. When I am using this SQL table in my application, I don't want to have to use [ ] all of the time to refer to a field name, so that is why I didn't use the wizard. I just need to understand how to write an import script within sql..<br />
<br />
Thank you.
</div>
</div>


This is probably pretty simple.. but I am drawing a blank. I went ahead and created a table that matches the fields in the Excel file. This reason I did this is that many of the field name in the Excel file were name very strangly. for example DQM# or Contact ID #. When I am using this SQL table in my application, I don't want to have to use [ ] all of the time to refer to a field name, so that is why I didn't use the wizard. I just need to understand how to write an import script within sql..

Thank you.

Import excel data in an already created SQL Table

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.