Home Forums SQL Server 2008 T-SQL (SS2K8) Import to MSSql from varying tab delimited text files RE: Import to MSSql from varying tab delimited text files

  • My select don't work properly (problem in the picture). I use SQL Server 2008r2.

    select * from OpenRowset('MSDASQL',

    'Driver={Microsoft Access Text Driver (*.txt, *.csv)};DefaultDir=D:\MALEP_BCP\CSV_VSND\;Extended properties=''HDR=YES; FMT=Delimited(;)''',

    'select * from pokus.csv')

    With schema.ini work OK.

    But I need use various delimited and defined in SQL.

    Help me pls.