Exporting dates to Excel from Access

#1 (**permalink**) 28-Jul-2006, 08:02 AM

When I export a table to Excel, I have a field that I want to populate with a
date that I put in through a pop up. However, when I open the Excel file-
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9475-exporting-dates-to-excel-from-access.html
all the data except the date has exported over. When I run it in Access,
(not exporting) it works fine.

Any Ideas?
--
Gina

*

#2 (**permalink**) 28-Jul-2006, 08:03 AM

Hello Gina.

"Gina" wrote:
> When I export a table to Excel, I have a field that I want to populate
> with a date that I put in through a pop up.

How is the popup generated?

> However, when I open the Excel file-all the data except the date has
> exported over. When I run it in Access, (not exporting) it works fine.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9475

The tablè?
What about creating a query that contains a parameter of type Date/Time
(MyDate) whose value is contained in the select list ([MyDate])?
Define the parameter via the "query, parameters" menu command.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9475
Then export the query instead of the table.

--
Regards,
Wolfgang

#3 (**permalink**) 28-Jul-2006, 08:03 AM

Awesome! Thank you very much. It worked wonderfully.
--
Gina

"Wolfgang Kais" wrote:

> Hello Gina.
>
> "Gina" wrote:
> > When I export a table to Excel, I have a field that I want to populate
> > with a date that I put in through a pop up.
>
> How is the popup generated?
>
> > However, when I open the Excel file-all the data except the date has
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9475
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9475
> > exported over. When I run it in Access, (not exporting) it works fine.
>
> The tablÃ¨?
> What about creating a query that contains a parameter of type Date/Time
> (MyDate) whose value is contained in the select list ([MyDate])?
> Define the parameter via the "query, parameters" menu command.
> Then export the query instead of the table.
>
> --
> Regards,
> Wolfgang
>
>
>