Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 25th 05, 09:03 PM
zeebyrd
 
Posts: n/a
Default Microsoft Access Report into Excel Spreadsheet

I do a report that uses an Access report that is downloaded into Excel for
presentation. The report is essentially a list of warranty claims,
containing individual claim information including open and close dates. A
problem was pointed out to me in the Excel report, though- the open and close
dates are all listed as 2005 dates, which is incorrect since most of the
claims were opened in 2004. Excel is systematically stating these dates as
the same month in 2005, for example 10/2005 instead of 10/2004. The query
that the Access report uses is pulling correct data, and the report in Access
is correct, the error dates show up after I download the report into Excel
from Access.

  #2   Report Post  
Old February 27th 05, 12:36 AM
Gary Brown
 
Posts: n/a
Default

From what you've described, it looks like your Access Report has the date
formatted something like 10/04, 10-04, Oct-04 or Oct 04.
When this is imported to Excel, Excel recognizes it at 10/04/2005. Reformat
the report to include a 4 digit year such as 10/2004, 10-2004, Oct-2004 or
Oct-2004. This will bring the information across as 10/01/2004 which can
then be reformatted as 10/2004.
HTH,
Gary Brown



"zeebyrd" wrote in message
...
I do a report that uses an Access report that is downloaded into Excel for
presentation. The report is essentially a list of warranty claims,
containing individual claim information including open and close dates. A
problem was pointed out to me in the Excel report, though- the open and
close
dates are all listed as 2005 dates, which is incorrect since most of the
claims were opened in 2004. Excel is systematically stating these dates
as
the same month in 2005, for example 10/2005 instead of 10/2004. The query
that the Access report uses is pulling correct data, and the report in
Access
is correct, the error dates show up after I download the report into Excel
from Access.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 3 February 12th 05 02:04 AM
MS Access in Excel Jackie Excel Worksheet Functions 4 February 11th 05 02:21 PM
Create New Microsoft Excel Worksheet Has 3 Sheets Bassam Setting up and Configuration of Excel 0 February 9th 05 08:51 PM
How do I import Microsoft Word files into Microsoft Excel? Excel New Users to Excel 1 January 9th 05 01:03 AM
Creating a Microsoft Words document from an existing Excel spreads ringo tan New Users to Excel 1 December 30th 04 08:01 PM


All times are GMT +1. The time now is 06:04 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017