<div>
For ANY kind of import, i do import to a staging table first, which has only varchar field(s). Then, with &quot;simply&quot; SQL, i can validate the data, and move it around to other tables, eventually other staging tables.<br />
<br />
You will have to write some long SQL, specifiying all the columns, splitting up the data, but you can be assured that this is the most easy-to-support and flexible solution i found until now.<br />
<br />
CHeers
</div>


For ANY kind of import, i do import to a staging table first, which has only varchar field(s). Then, with "simply" SQL, i can validate the data, and move it around to other tables, eventually other staging tables.

You will have to write some long SQL, specifiying all the columns, splitting up the data, but you can be assured that this is the most easy-to-support and flexible solution i found until now.

CHeers

<div>
thks for the help, have solve it after various try, ur comment did give me some idea to furthur my experiment. 
</div>


thks for the help, have solve it after various try, ur comment did give me some idea to furthur my experiment.

<div>
<div class="content wysiwyg-content">
trying to load a text files into 2 mssql tables. the text file contains rows of record where if it starts with H (header) will go to tab1 &amp;&nbsp;if it starts with numeric will go to tab2.<br />
<br />
example of the text file are like this<br />
<a href="http://www.geocities.com/alexlow2020/sample.txt" rel="ugc">http://www.geocities.com/alexlow2020/sample.txt</a><br />
<br />
and i have to import into below table<br />
<a href="http://www.geocities.com/alexlow2020/table.jpg" rel="ugc">http://www.geocities.com/alexlow2020/table.jpg</a><br />
<br />
the text file have fix char location &amp;&nbsp;i have to extract it out to put into specific col. <br />
<br />
anyone have any ideas how to do this or done it b4 ? thanks<br />
<br />

</div>
</div>


trying to load a text files into 2 mssql tables. the text file contains rows of record where if it starts with H (header) will go to tab1 & if it starts with numeric will go to tab2.

example of the text file are like this
http://www.geocities.com/alexlow2020/sample.txt

and i have to import into below table
http://www.geocities.com/alexlow2020/table.jpg

the text file have fix char location & i have to extract it out to put into specific col. 

anyone have any ideas how to do this or done it b4 ? thanks



import flat file into two tables

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.