Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Zombieslug
Starting Member
1 Post |
 Posted - 2011-11-04 : 15:53:48
|
| Hello everyone!I am new to SQL and know almost nothing about it, so bear with me. I have a company running a database for me and I would like them to send me backups that I can view in Access or Excel. Currently they send me .sql files. I've requested the other formats but they tell me it will take some development time to export them as Access or Excel. From my searches on the net it seems like they only need to use a wizard. Am I right? or is it more than that? Also is there a program or something I can use to view the .sql backup? |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-11-07 : 08:10:48
|
| Depends on what the .sql is.>> it seems like they only need to use a wizard Depends on their system. They probably have something automated so they wound need to develop to produce a different format and also make sure the changes don't affect other customers.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
alexylee
Starting Member
14 Posts |
Posted - 2011-11-09 : 13:00:20
|
| If you want to get your data in Excel, you can use this handy tool.This tool converts/exports SQL Table or TSQL query resultset to Excel file.[url]http://www.sqlmgmt.com/sql/Convert-SQL-to-Excel[/url]You can either run this tool yourself or let them run it and give you an output Excel file.http://www.sqlmgmt.com |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Exporting