Link to home
Start Free TrialLog in
Avatar of WLMN
WLMNFlag for United Kingdom of Great Britain and Northern Ireland

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
ASKER CERTIFIED SOLUTION
Avatar of James Murrell
James Murrell
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of WLMN

ASKER

Hi,
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?
Avatar of WLMN

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!