神马品牌网《青花瓷》舞蹈视频:如何创建一个SQL数据库?
来源：百度文库 编辑：神马品牌网 时间：2024/04/25 21:13:07
比如一个EXCEL表中的数据如何导入SQL中 就是要创建一个关于某个EXCEL表的数据库 还望高人指教
Dim cn As Connection
Dim str As String
str = "CREATE DATABASE Sales " & _
"ON (NAME = Sales_dat," & _
"FILENAME = 'D:\saledat.mdf'," & _
"SIZE = 1MB,MAXSIZE = 5MB,FILEGROWTH = 10% )" & _
"LOG ON ( NAME = 'Sales_log'," & _
"FILENAME = 'D:\salelog.ldf'," & _
"SIZE = 1MB,MAXSIZE = 5MB,FILEGROWTH = 5MB )"
Set cn = New Connection
With cn
.ConnectionString = "Provider=SQLOLEDB.1;Data Source=pmserver;User ID=sa;Password=sa"
.Open
.Execute str
End With
Set cn = Nothing
---------------------------------------------------------------
Dim cn As Connection
Dim str As String
str = "CREATE DATABASE Sales " & _
"ON (NAME = Sales_dat," & _
"FILENAME = 'D:\saledat.mdf'," & _
"SIZE = 1MB,MAXSIZE = 5MB,FILEGROWTH = 10% )" & _
"LOG ON ( NAME = 'Sales_log'," & _
"FILENAME = 'D:\salelog.ldf'," & _
"SIZE = 1MB,MAXSIZE = 5MB,FILEGROWTH = 5MB )"
Set cn = New Connection
With cn
.ConnectionString = "Provider=SQLOLEDB.1;Data Source=pmserver;User ID=sa;Password=sa"
.Open
.Execute str
End With
Set cn = Nothing
---------------------------------------------------------------
CREATE DATABASE database_name On Primary (Name=databasename,Filename=xxxx.mdf,Size=15MB,Filegrowth=10%) Log On (Name=databaselog,Filename=xxxx.ldf,Size=3MB,Maxsize=10MB,FileGrowth=1MB)
进入SQL后，选定一个表作为你要导入EXCEL的表，然后电击右键，选择“导入数据”……然后注意数据源的选择是要选EXCEL2000，然后在根据提示选择你要导入的表，极其简单，自己一看就知道了！