I don't know about directly into a variable but you might be able to use
Bulk Insert (depending on the file) into a table then select from the table
to a variable.
Andrew J. Kelly
SQL Server MVP
"Anand" <org> wrote in message