[AccessD] Exporting from an Access Report to Excel

[Bill Benson]

"Best?" says who? I happen to think what is "best" is assigning a query to
a recordset, and automating Excel direct from Access and using the
CopyFromRecordset property of the Range object to populate a designated
range.

Best is in the experience of the developer and the reliability as perceived
by both that person and the user.

On Fri, Oct 28, 2016 at 12:27 PM, Brad Marks <bradm at blackforestltd.com>
wrote:

> All,
>
> I know that it is best to export from an Access   *query*   to Excel.
>
> However, I have a couple Access   *reports*   that a user would like in
> Excel.
>
> One report exports to Excel very nicely.
>
> The second report will export to Excel, but the data in one of the columns
> is missing.
>
> I am curious as to why this happens.  Are there any guidelines on
> exporting Access reports to Excel?
>
> I cannot understand why most columns export nicely, but one column does
> not.
>
> Thanks,
>
> Brad
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>