Re: exporting data into an excell spreadsheet

From: Rognvald Bjarne <wear_u_out_at_nospam.hotmail.com>
Date: Tue, 22 Aug 2000 13:39:42 -0600
Message-ID: <HFAo5.1827$WEW6.16056441@news.randori.com>

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.
Received on Tue Aug 22 2000 - 14:39:42 CDT