Importing Excel Spreadsheets into SQL Server

08/09/2008, 12h44

I have a complex spreadsheet with about 15 worksheets, which are all linked
together and a large number of macros. I want to import all data and
functions into a sql database and eventually create a desk application.

Can anyone suggest a way of doing this?

08/09/2008, 13h33

1) Linked Server
2) SSIS (SQL Server 2005)
3) DTS (SQL Server 2000)

"Stephen Lewis" <Stephen Lewis@discussions.microsoft.com> wrote in message
news:9B0137DE-72C2-4875-9363-7B533DEDF487@microsoft.com...
>I have a complex spreadsheet with about 15 worksheets, which are all linked
> together and a large number of macros. I want to import all data and
> functions into a sql database and eventually create a desk
> application.
>
> Can anyone suggest a way of doing this?

08/09/2008, 12h44	#1
Stephen Lewis Messages: n/a Hébergeur:	Importing Excel Spreadsheets into SQL Server I have a complex spreadsheet with about 15 worksheets, which are all linked together and a large number of macros. I want to import all data and functions into a sql database and eventually create a desk application. Can anyone suggest a way of doing this?

08/09/2008, 13h33	#2
Uri Dimant Messages: n/a Hébergeur:	Re: Importing Excel Spreadsheets into SQL Server 1) Linked Server 2) SSIS (SQL Server 2005) 3) DTS (SQL Server 2000) "Stephen Lewis" <Stephen Lewis@discussions.microsoft.com> wrote in message news:9B0137DE-72C2-4875-9363-7B533DEDF487@microsoft.com... >I have a complex spreadsheet with about 15 worksheets, which are all linked > together and a large number of macros. I want to import all data and > functions into a sql database and eventually create a desk > application. > > Can anyone suggest a way of doing this?

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email