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 |
|
jallendo
Starting Member
1 Post |
 Posted - 2009-05-31 : 11:38:51
|
| I have a mssql 2005 express database that I am using to store data about products for the pos system in my store. The database has been being updated through the pos software but there is no option inside the pos software to export the database into any form that can be read by excel.I then spent some time with google and read about dtswizzard.exe which wasn't installed on my machine, so I went out and downloaded and installed that. For some reason it still never showed up. I also installed the sp3 patch for my mssql server which also failed to produce dtswizzard.exe. That was a bit confusing so I decided to try and find a new solution. I found EMS sql manager 2005 lite. With this program I was able to extract a file that is a .sql file. Excel could not read this file type.I was wondering if there is either a method of converting or loading the sql file. If not are there any other methods of exporting this database into excel? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Trouble exporting mssql database