If you don't choose .csv format, you can use .xls. In .csv format all column
will be interpreted as varchar. But if you transfer from excel, it can be
different respect to the column types in excel. But, there is an important
point.

"Ahmad Jalil Qarshi" wrote:

hi!

i want to transfer data from MS Excel Sheets to SQL Server. is there any
way.


Thanks

Ahmad Jalil Qarshi