<div>
If it's only 200 rows, BULK INSERT into a #TempTable and then select the columns you need into your target table
</div>


If it's only 200 rows, BULK INSERT into a #TempTable and then select the columns you need into your target table

<div>
Thanks for the reply bamboo7431.<br />
<br />
I get the TempTable storage but could you expand abit on the &quot;Select columns into target table&quot; bit?<br />
<br />
thanks,<br />
<br />
Nellster
</div>


Thanks for the reply bamboo7431.

I get the TempTable storage but could you expand abit on the "Select columns into target table" bit?

thanks,

Nellster

<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
I am building a solution using SQL Server Express 2005. Part of this solution will be the ability to bulk upload a database table from a csv file once a day. The csv file will contain approximately 200 rows with about 50 fields in each row. The database table will contain columns that will not be present on the csv. <br />
<br />
I am relatively new to &quot;bulk inserts&quot; and updating from csv/text files so could appreciate some assistance as to the best way of approaching this. I have imported from a CSV to MS Access before and could manipulate and match cvs columns to database table columns but I'm not sure as to the best way to do it in SQL 2005.<br />
<br />
Many thanks for assistance in advance!<br />
<br />
Nellster
</div>
</div>


Hi all,

I am building a solution using SQL Server Express 2005. Part of this solution will be the ability to bulk upload a database table from a csv file once a day. The csv file will contain approximately 200 rows with about 50 fields in each row. The database table will contain columns that will not be present on the csv. 

I am relatively new to "bulk inserts" and updating from csv/text files so could appreciate some assistance as to the best way of approaching this. I have imported from a CSV to MS Access before and could manipulate and match cvs columns to database table columns but I'm not sure as to the best way to do it in SQL 2005.

Many thanks for assistance in advance!

Nellster

Insert table via csv with non matching columns?

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

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.