Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
    >
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page