CSV Download

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Simon Harris (too-much-spam_at_makes-you-fat.com)
Date: 10/26/04 

Date: Tue, 26 Oct 2004 22:58:59 +0100

Hi All,

I have created a script which connects to a SQL DB, runs a query, writes the
results out to a file (Using FSO) then presents the user with a link to
download the CSV.
As the file contains sensitive data, I dont want to leave the file on the
server, and I dont want to rely on the user to delete the file after every
export.

Does anyone have any suggestions?

Thanks,
Simon.

Relevant Pages

  • Re: Syntax error in INSERT INTO Statement
    ... I dont know what was wrong in my code ... running the query ... >keep a QueryDef set up as an SPT and stuff it w/ an SQL ... >> OrderHeaderId, OrderDetailId, CreatedDate, CreatedBy)" ...
    (microsoft.public.access.queries)
  • Re: ADO teething problems
    ... Try inserting or pasting more data ... ... like the SQL of the Insert Query. ... As you wish - although i dont think it will help much. ...
    (comp.databases.ms-access)
  • RE: Extract certain Columns for Report
    ... is what is needed, I just dont know what to do, I tried sql ... reports ng will bring some resolve, been working on this thing for weeks. ... macro, a query, vba..... ...
    (microsoft.public.access.reports)
  • RE: MS Access Query using calculated field - Access ignores criteria.
    ... SQL from your query and I'll take a look. ... record I want excluded does not exist in the LastOfBudgetLimit output query ... So dont understand why that would be a problem. ...
    (microsoft.public.office.developer.automation)
  • Re: multi table multi database join?
    ... dont i have some kind of filter? ... sybase runns on one machine mssql on another, ... the data from the aggregate db could be used in a query to ...
    (microsoft.public.dotnet.framework.adonet)