Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Export to Excel From Access - File Error. Number Formats Lost

Posted on 2011-09-30
13
Medium Priority
?
1,194 Views
Last Modified: 2012-05-12
Hello.

I'm using a macro to export data from an Access query to Excel.  It works fine but when I open the Excel File I get a dialog that says "File Error.  Some number formats may have been lost."

If I click OK everything looks as it should but this is an annoyance I'd like to do away with.  I've tried saving to .xls and .xlsx with no difference.

Any Ideas how I can fix this (from within Access preferably)?  

Thanks!
0
Comment
Question by:ttist25
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
  • 2
  • +1
13 Comments
 
LVL 19

Assisted Solution

by:Richard Daneke
Richard Daneke earned 664 total points
ID: 36894006
Please help us by providing version numbers.  2010, 2007, 2003 ?
0
 
LVL 19

Expert Comment

by:Richard Daneke
ID: 36894010
Which Macro action do you use to create the Excel file?   Are you using a template?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36894328
Yes, and also post a sample of the resulting Excel file.

Sometimes these warnings are precautionary...
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36894332
...and not really indicative of any real issue with the file
0
 
LVL 1

Author Comment

by:ttist25
ID: 36895136
Sorry - I'm using Access and Excel 2007.  I have tried saving to xls or xlsx with the same result.  

The macro I'm using has the following properties:
Object type: Query
ObjectName: MyQueryName
Output Format: Excel 97 - Excel 2003 Workbook (*.xls)
AutoStart: yes
OutputQuality: Screen

I am not using a template.  And you are correct, there's nothing wrong with the data in the file but I'd like to not have the dialog box pop up.  It makes it look broken :)

Thanks for your help!
0
 
LVL 8

Accepted Solution

by:
hello_everybody earned 668 total points
ID: 36898470
0
 
LVL 1

Author Comment

by:ttist25
ID: 36903970
Hi HE

That is what I'm dealing with and I had looked at that solution before posting.  I was hoping for something more graceful but I'm not finding much.  

Any other ideas?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36904753
So will you be posting a sample file as I requested?
Yes or no?
0
 
LVL 1

Author Comment

by:ttist25
ID: 36904872
Hi Boag,

Thanks for your offer to help.  I don't want to seem ungrateful but, I'm concerned about posting the file.  I hope you understand.  

Is there something specific you would be looking for that I might be able to check?

0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36905025
All we would need is a file that generates the same error.

So you can use the same file and obfuscate the data...
Or create a junk table and query and export that...

...as long as it generates the same error when opened in Excel...
0
 
LVL 1

Author Comment

by:ttist25
ID: 36924006
Hi guys,

I've been trying to get a file that will do the same thing but as soon as I change it to obfuscate the data it stops throwing the error.  It's kind of strange.  If I crate the Excel file from the macro in Access it opens up and I get the error.  If I close the spreadsheet and then open it back up again, I get the same error.  

But, if I click the save button in Excel without modifying any of the data and then open it back up again I don't get the error.  
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 668 total points
ID: 36924634
Then obfuscate the source data (the input) ...
Then you should get obfuscated data, that generates the error..., right?...
0
 
LVL 1

Author Closing Comment

by:ttist25
ID: 36986262
Thanks guys.  Sorry for taking so long to close this.  It wasn't really resolved but HelloEverbody's solution would likely have fixed it.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question