Analyze It with MS Office Excel

D

Don

Hello, I have a Access 2003 report, one of the fields on the report display
data like 09-4952 they then use the "Analyze It wtih MS Office Excel"
feature, when this value gets to Excel it looks like 1114966. Is there any
properties I can set to keep the 09-4952

Thanks
 
S

Sam Davis

Don,

I'm not expert on MS-Excel, however it seems Excel is interpreting 09-4952
as a date. The integral value for the date 1st Sep 4952 is 1114966. Would be
worth a try to convert the 09-4952 field to a string (using Str() in your
query) and see if that causes Excel to also see the value as a string.

HTH
Sam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

analyze it with microsoft office excel 1
Analyze with Excel 2
Can Access 2007 analyze w/Excel? 5
Using Analyze Access report with Microsoft office Excel 2
Analyze It with MS Office Excel Vs. DoCmd.TransferSpreadsheet 1
Excel Analyzing 3
Analyze it With Excel via Code 1
Analyze it with Microsoft Excel 2

Top