>I am trying to import a excel file to SQL server through DTS,when I am running the package, geting an error that says "Data for souce column18(REFERENCE) is too large for the specified buffer size. I have column called REFERENCE in excel file that contains large text.
>
>Thanx
>Alex

Not sure if this is the problem, but Reference is a reserved word in SQL Server. Change the column name and try again.

I had to do something similar when I upscaled from VFP to SQL Server except I had to change table names, not field names.

HTH.