microsoft.public.access.forms

I don't work with excel, but if this was me I would check not only the
formats on all the fields in the table, but the datatypes. It may be a
datatype in the Access table not acceptable for the usage in the
spreadsheet. For example, you have a text field in the Access table holding
date Values, but it isn't a Date type field. So check that the Data fields
are compatible.

God Bless,

Mark A. Sam


"scott04" wrote in message
news:F89C6A60-E992-4383-90E0-6155443590C8@microsoft.com...
> Hi everyone,
> I have a marco that exports a report to excel format. When I open the
> excel
> spreadsheet it states "File Error. Some number formats may have been
> lost."
> I examined the spreadsheet and the only problem is my receiveddate field
> is
> showing in number format. In my table design i did have an input mask of
> 99/99/0000;0;_ and thought this may be causing the problem. I took out
> the
> mask but still get the same error. Can someone offer me a reason why this
> may be happening and a possible workaround/solution? Thanks.