Exporting dates to Excel from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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-
all the data except the date has exported over. When I run it in Access,
(not exporting) it works fine.

Any Ideas?
 
Hello Gina.

Gina said:
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.
Click to expand...

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.
Click to expand...

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.
 
Awesome! Thank you very much. It worked wonderfully.
--
Gina


Wolfgang Kais said:
Hello Gina.

Gina said:
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.
Click to expand...

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.
Click to expand...

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.
Click to expand...
 
Back
Top