import excel files

how can I import excel files into msde 2000
Hi ,
MSDE does not support DTS and other advanced features supported by the
regular versions of sql server.
But a work around is to get a evaluation CD of sql server and then install
the client components of sql server . Once it is installed sucessfully you
can use the import export wizard to export data into the msde instance.
Hopefully this answers your question
Girish Sundaram
This posting is provided "AS IS" with no warranties, and confers no rights.
|||hi,
"TJS" <nospam@.here.com> ha scritto nel messaggio
news:10qa413mkh5j0c5@.corp.supernews.com
> how can I import excel files into msde 2000
you can set up a linked server to the xls file and get relevant data into
your MSDE table...
consider having a d:\Students.xls file with 2 columns, FirstName and
LastName ...
SET NOCOUNT ON
CREATE TABLE dbo.Students (
FirstName VARCHAR(10) ,
LastName VARCHAR(10)
)
GO
EXEC sp_addlinkedserver 'ExcelSource',
'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
'd:\Students.xls',
NULL,
'Excel 5.0'
GO
EXEC sp_addlinkedsrvlogin 'ExcelSource', 'false', 'sa', 'Admin', NULL
GO
SELECT * FROM ExcelSource...[Foglio1$] -- that's [Sheet1$] for English
version :D
-- import into your base table...
INSERT INTO dbo.Students SELECT * FROM ExcelSource...[Foglio1$] -- that's
[Sheet1$] for English version :D
SELECT * FROM dbo.Students
GO
-- final clean up, dropping the linked server and the base table
EXEC sp_dropserver 'ExcelSource', 'droplogins'
GO
DROP TABLE dbo.Students
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||How do you create the 'ExcelSource'
|||hi,
"TJS" <nospam@.here.com> ha scritto nel messaggio
news:10qhkoi9ittcl93@.corp.supernews.com
> How do you create the 'ExcelSource'
the 'ExcelSource' just defines a linked server, pointing to the file system
specified Excel file, using the JET OLE DB provider...
but perhaps I do not understand your question
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply