Re: exporting data into an excell spreadsheet

From: <tommychill_at_my-deja.com>
Date: Tue, 22 Aug 2000 20:21:24 GMT
Message-ID: <8nunbc$alp$1@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. Received on Tue Aug 22 2000 - 15:21:24 CDT