WLMN
asked on
How can I export data from SQL2005 files to an excel sheet?
Hi people,
I have a memory stick of 4 GB which contains a liitle data base in SQL 2005. This device was given to me in order to extract all data and put data in an excel sheet. I have no experience at all with SQL and I do not know how to archive that.all the data can access on the device but I do not know how to export it as I could not find any options to do so.
I attached two pictures to give you an idea of what I see when accessing the device and data on it.
I look forward to your reply!
SQL2005.bmp
SQL-Inventory-1.bmp
I have a memory stick of 4 GB which contains a liitle data base in SQL 2005. This device was given to me in order to extract all data and put data in an excel sheet. I have no experience at all with SQL and I do not know how to archive that.all the data can access on the device but I do not know how to export it as I could not find any options to do so.
I attached two pictures to give you an idea of what I see when accessing the device and data on it.
I look forward to your reply!
SQL2005.bmp
SQL-Inventory-1.bmp
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi,
The thing is I've installed SQL 2005 but for some reason I do not have installed or cound find on my conputer SQL Server Integration Services. If I go to "All Programs" - "Microsoft SQL server 2005" i only have one option " Configuration Tools".
So....What do I need to do to install or access SQL Server Integration Services in order to run Business Intelligence project?
Sorry people but this my first time when dealing with that!
The thing is I've installed SQL 2005 but for some reason I do not have installed or cound find on my conputer SQL Server Integration Services. If I go to "All Programs" - "Microsoft SQL server 2005" i only have one option " Configuration Tools".
So....What do I need to do to install or access SQL Server Integration Services in order to run Business Intelligence project?
Sorry people but this my first time when dealing with that!
ASKER
Thank you for the above information.
In order to try the above steps I would like to know what i need to have installed on my computer in order to archive what i want.
I've installed SQL 2005 but I do not know how to create a Business Intelligence project ! Do I need to install to create business intelligence project?