Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Exporting dates to Excel from Access

Discussion in 'Information Technology' started by Gina, Jul 28, 2006.

  1. Gina

    Gina
    Expand Collapse
    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?
    --
    Gina
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News BREAKING: Young Sikh Shot Dead In Jalalabad, Afghanistan . - Sikh24 News & Updates Breaking News Oct 2, 2016
    Pacific Oil slicks spotted in search for missing Malaysia Airlines plane (Live updates) Breaking News Mar 8, 2014
    India Candidates flock to Dera Sacha Sauda Breaking News Jan 17, 2012
    India Seven SAD Candidates of SGPC Win Unopposed Breaking News Aug 27, 2011
    GurmatChanan Updates Gurbani Download Aug 27, 2011

  3. Wolfgang Kais

    Wolfgang Kais
    Expand Collapse
    Guest

    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.


    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
     
  4. Gina

    Gina
    Expand Collapse
    Guest

    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
    > > 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
    >
    >
    >
     

Share This Page