sql server 2008: importing data from excel 2003 fi

问题:

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 ?

回答1:

For Express, run C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSWizard.exe

回答2:

try using the sql server management studio

right click in your database -> Tasks -> Import Data..

check this link for more info

How to: Run the SQL Server Import and Export Wizard

回答3:

SQL Server has an import wizard that works with .xls files.

回答4:

The import wizard generates an SSIS package for you. If you want more control, you can create the SSIS package yourself in Visual Studio.

回答5:

SQL Server Integration Services for the win. Check this out!