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 |
|
dtrivedi
Posting Yak Master
153 Posts |
 Posted - 2010-08-12 : 10:32:52
|
| I ran a SQL statement using the ISeries navigator is there a way to export the data to excel? i dont see any options for it at all when i copy and paste it it doesn't copy over the column headings and since the table is huge it would get too confusing without the column headingsthanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-12 : 13:02:13
|
| Don't know about Navigator, but you can run a pass-through query directly from Excel |
 |
|
|
dtrivedi
Posting Yak Master
153 Posts |
Posted - 2010-08-12 : 13:37:41
|
| i don't think I can do it directly from excel to the AS400 can I?? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-08-12 : 15:14:36
|
| The Navigator has limited export capabilities IIRC. How about the Data Import and Export Wizards? You can put a query in there and export to CSV. |
|
|
|
dtrivedi
Posting Yak Master
153 Posts |
Posted - 2010-08-12 : 16:03:01
|
| that didn't work...it takwes 3 hrs to export the table because of the size and when i open in it excel theres nothing there... |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-12 : 16:32:40
|
| excel only holds 65,556 records |
|
|
|
dtrivedi
Posting Yak Master
153 Posts |
Posted - 2010-08-16 : 08:44:04
|
| hmm that explains why it wasn't working. Thanks I actually learned how to Run a Script on ISeries and now am going forward from there... |
|
|
|
|
|
|
iseries navigator