Thank you very much.

I have old desktop bought 7 years ago and it is working fine for SQL server 2008.

You can bought old machine in very less cost and start your work.

There is no inbuilt function but there are couple of ways that can be applied to your problem.

These approaches are trade off between performance and simplicity.

The best approach is custom...

I think it could be possible only after attaching textbox to data container like Table or List Item and setting its dataset propery to valid dataset name.

You can use following :-

=IIF(Fields!column.Value="" OR ISNOTHING(Fields!column.Value),"?",Fields!column.Value)

Hi,

You can also use following command

SELECT * FROM

OPENROWSET('Microsoft.Jet.OLEDB.4.0','Text;Database=D:\vinod work\;HDR=NO','SELECT * FROM test.txt')

This is working...

Vinod

You can use following script in order to import Text file.

SELECT * FROM

OPENROWSET('Microsoft.Jet.OLEDB.4.0','Text;Database=D:\File_path\;HDR=NO','SELECT * FROM FileName.csv')

OR

Alternatively, You can create schema file for custom delimiter in the same path...

I think It can be done via small trick.

Just add Column heading in your text file dynamically using DOS Copy file command and then mention column name you need...

Jim,

You can use following query to import Excel sheet into temp table.

SELECT * into #InsertQueues FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;HDR=NO;IMEX=1;Database=D:\path\excel_file.xls', 'SELECT * FROM [sheet1$]')

Please specify complete path of your excel file...