Hi all,
I would like to replace the default directory location (c:\temp) and the
filename (emails.csv) with variables like @FileDir and @FileName in the
statement below.
SELECT @cnt = COUNT(*) FROM OpenRowset('MSDASQL', 'Driver={Microsoft Text
Driver (*.txt; *.csv)}; DefaultDir=c:\temp;','select * from "emails.csv"')
However, my attempts have not been successful.
Any ideas appreciated, and TIA.
Greg