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 |
|
parag.sv
Starting Member
11 Posts |
 Posted - 2009-11-24 : 16:07:04
|
| Hi all,I have been asked to get the output of a SQL query to an access file.. and i need help in doing it.The query i have uses multiple databases and table and generates an output of 4 million rows.Since Microsoft excel supports maximum of 1 million row, i have to create 4 excel files for the same..which is not acceptable by my client.They want to see all 4 Million rows in a single file and excel does not support this.Someone told me that I can use MICROSOFT ACCESS for doing so.i.e. Direct the query output to access file.I have never worked with ACCESS and dont know how to do it? I tried to dig into the SSIS tool to find if that was possible, but i am still stuck.Any help will be really appreciated.Thanks, |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-28 : 02:00:41
|
| i think what you need is data flow task with oledb source containing your query and access connection for destination. |
 |
|
|
|
|
|
SSIS for putting SQL query output to access file