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 |
|
markperry
Starting Member
1 Post |
 Posted - 2005-12-06 : 11:58:46
|
| I've set up a DTS job to import data from an Access table into an Excel spreadsheet. Every time the job runs the excel table is dropped and recreated, but the data is written further down the excel page, i.e. every time the job runs another 43 blank lines (no of rows) are added above the data, meaning the user has to scroll down further and further each time.Any suggestions? |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-12-07 : 03:25:29
|
| Can you not use the Import Data feature of Excel (and possibly set it to refresh on open)?steve-----------Facts are meaningless. You could use facts to prove anything that's even remotely true! |
 |
|
|
|
|
|
Using DTS to import Access into Excel