Re: exporting data into an excell spreadsheet

That is controllable by the query you create using the get external data command within XL.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
<tommychill_at_my-deja.com> wrote in message
news:8nunbc$alp$1_at_nnrp1.deja.com...


> thanx for the idea...

>

> Once I save the file, will it update automatically when new data is

> enter into the database or will I have to "re-query" the db?

>

>

>

> In article <HFAo5.1827$WEW6.16056441_at_news.randori.com>,

>   "Rognvald Bjarne" <wear_u_out_at_nospam.hotmail.com> wrote:

> > CREATE TABLE <table> AS... <select query>

> >

> > create a DSN through ODBC

> >

> > then open up Excel and query it using MS Query;  Access will also work

 if


> > you don't have MSQ setup.

> >

> > <tommychill_at_my-deja.com> wrote in message

> > news:8nueit$vgp$1_at_nnrp1.deja.com...

> > > I need to export some data into an excell spreadsheet. The

 spreadsheet


> > > is more than just a simple "name", addr1", etc spreadsheet.

> > >

> > > I need to have certain columns containing formulas and such. I know

 I


> > > can create an "ugly way" of doing this, but is there a "slick" way

 of


> > > expediting the process.

> > >

> > > thanx,,,,,

> > >

> > >

> > > Sent via Deja.com http://www.deja.com/

> > > Before you buy.

> >

> >

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.