Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / June 2006

Tip: Looking for answers? Try searching our database.

Exporting data from access to excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tasha - 29 Jun 2006 14:01 GMT
A report I use to export to excel from Access using "DoCmd.OutputTo acReport,
ReportName" is now providing me with different values.  Data like 12-1369 is
returning a value of -193607.  Note:  not all the values are changed.  It is
very inconsistent.  Thanks!  
John Nurick - 29 Jun 2006 19:31 GMT
Hi Tasha,

And your question is?<g>

This sort of thing sometimes happens if there's a text value in Access
that Excel assumes is a number or a date. If it's never happened before
and is happening now, something has changed, in your Microsoft Office
setup, your database, or your data.

One approach that usually the problem is to prefix the field values in
question with an apostrophe: this forces Excel to treat thenm as text.

If you post back with some examples of the exact values that are
displayed in the report when previewed, and the corresponding values
displayed by Excel after export, someone may be able to make a better
suggestion.

>A report I use to export to excel from Access using "DoCmd.OutputTo acReport,
>ReportName" is now providing me with different values.  Data like 12-1369 is
>returning a value of -193607.  Note:  not all the values are changed.  It is
>very inconsistent.  Thanks!  

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
Tasha - 30 Jun 2006 13:25 GMT
John, I'm sorry but I'm not seeing your reply.

thanks!

> A report I use to export to excel from Access using "DoCmd.OutputTo acReport,
> ReportName" is now providing me with different values.  Data like 12-1369 is
> returning a value of -193607.  Note:  not all the values are changed.  It is
> very inconsistent.  Thanks!  
John Nurick - 30 Jun 2006 21:37 GMT
Here it is again:

This sort of thing sometimes happens if there's a text value in Access
that Excel assumes is a number or a date. If it's never happened before
and is happening now, something has changed, in your Microsoft Office
setup, your database, or your data.

One approach that usually the problem is to prefix the field values in
question with an apostrophe: this forces Excel to treat thenm as text.

If you post back with some examples of the exact values that are
displayed in the report when previewed, and the corresponding values
displayed by Excel after export, someone may be able to make a better
suggestion.

>John, I'm sorry but I'm not seeing your reply.
>
[quoted text clipped - 4 lines]
>> returning a value of -193607.  Note:  not all the values are changed.  It is
>> very inconsistent.  Thanks!  

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.