sql server 2008：从excel 2003文件导入数据 [英] sql server 2008: importing data from excel 2003 file

问题描述

我有一个非常简单的excel文件，我需要导入到sql server 2008中的表。

i have a very simple excel file that i need to import into a table in sql server 2008.

其中一个字段有点复杂，我不认为它可以有效地保存到csv，因为它有时会有comas和单引号。当我保存到csv时，它弄坏了格式。所以我想尝试从xls文件直接导入。

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.

有没有人知道如何从xls导入到sql server？

does anyone know how to import from xls to sql server ?

推荐答案

p>对于Express，运行C：\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSWizard.exe

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

这篇关于sql server 2008：从excel 2003文件导入数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！