Monthly Archives: March 2009

VB.NET – Show and Mark File in Explorer

‘ VB.NET – Show and Mark File in Explorer Public Sub SelectFile(ByVal What As String) Microsoft.VisualBasic.Shell("explorer /e,/select," & What, AppWinStyle.NormalFocus) End Sub Datei im Explorer anzeigen und markieren

Posted in Code Snippets | Leave a comment

SQLSERVER – OPENROWSET / MSDASQL to read CSV/TSV files

The following will read a csv file. SELECT * FROM OPENROWSET (‘MSDASQL’, ‘Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=c:\data;’, ‘SELECT * from test.csv’); The following will read a tsv file (with a txt extension). SELECT * FROM OPENROWSET (‘MSDASQL’, ‘Driver={Microsoft Text Driver … Continue reading

Posted in SQL Server 2005 | Leave a comment