i have a very simple excel file that i need to import into a table in sql server 2008.
one of the fields is a bit complex and i dont think it can be saved effectively to a csv, since it sometimes has comas and single quotes in it. it screwed up the formatting when i save to a csv. so i would like to try to import directly from the xls file.
does anyone know how to import from xls to sql server ?