Hi,

I have created a data report in access 97 and I would like to transfer the
data from access to excel 97, format the fields and save the report .

I don't know how to send the data directly -with VBA code-from access to
excel.

Thanks,

T.

Hi Anastasios

My name is Tim Macaulay of the Microsoft Access Newsgroup Support team.  I
will be working with you on the issue that you are experiencing with the
Microsoft Access product.

You can utilize the TransferSpreadsheet Method/Action to export information
from Microsoft Access to Microsoft Excel.  If the Microsoft Excel
spreadsheet is formatted in a special manner, you may need to automate
Microsoft Excel and loop through the table and populate the cells with
information.

You can reference the Microsoft Access Help file, while in the VBA
Environment for more information on the TransferSpreadsheet Method/Action
by searching on TransferSpreadsheet.

Please let me know if how things work out for you.

Thank you for using the Microsoft Access Newsgroups,

Tim Macaulay
Microsoft Support
Monday through Thursday - 8:30 A.M. to 7:30 P.M.

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

On Sun, 17 Feb 2002 13:23:01 +0000 (UTC), "Anastasios Astyfidis"

see if my ideas in tip # 23 and 24 on my web site help.

----------------
Richard "ManxMan" Killey

www.comeandread.com/access

visit my site for tips

Try Active XL Report

--
Andrei Smolin
Easy way to Excel reporting at www.ActiveXLReport.com