Access Export to Preformated Excel Document

  • Thread starter Thread starter Daryl Hageman
  • Start date Start date
D

Daryl Hageman

I have a need to move data from an Access 2000 database,
into a fixed format Excel 2000 spreadsheet. I have built
the query, with the identical fields, in the Excel
spreadsheet, but need to be able to move the data into the
spreadsheet, without manually manipulating the data in
Excel.

Would like the process to be as automated as possible, any
suggestions?
 
Hi Daryl,

There's no really simple way of doing this. As you've seen, the built-in
export routine doesn't preserve cell formats. The basic approaches are
to use Automation to

(1) write code that exports the data into the workbook in the usual way
and then formats the cells as required

(2) write code that places the data into existing formatted cells
without disturbing the formatting.

This article
http://support.microsoft.com/default.aspx?scid=kb;en-us;247412 discusses
various ways of transferring data from Visual Basic applications to
Excel, and most of the methods it describes can equally be used in
getting data from an Access application.
 
Back
Top