Data Query Question - Built in W2K - Works Fine - Run on XP - Fai

[pcrimi]

(I am using Excel 2002 on all PC's.)

I have an Excel spreadsheet that uses an ODBC connection to three joined
VisualFoxpro Tables.

When I run this spreadsheet on a Windows 2000 Professional, I am able to
edit the Query, change a Date criteria field, and receive the data that I am
interested in.

When I run this spreadsheet using a Windows XP Pro PC, it the Date field
from the query does not work correctly. Refreshing the results of the query
from the spreadsheet returns only records with a blank date. Editing the date
field inside Microsoft Query also provides incorrect results.

How do I allow my Windows XP users to access this query?

Thanks
Pete

 

[Nick Hodge]

Pete

the only thing I can think of if the query returns nothing is that there is
an issue with window's regional settings.

Try typing a data that may be universal like 01/01/2005

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[pcrimi]

Thanks for your response.

I looked at the Windows Regional settings in VFP, (VFP 5.0) and they are the
same on the W2K PC and the XP PC. Are there settings in Excel that I can
check?

I just tried editing the date again and I have more specifics on what's
happening.
I'm trying to filter out records who's adddate field is greater than
12/31/2004.
The Criteria field shows Adddate >#12/31/2004#. Executing the query filters
out only non-blank adddate records. Changing the filter to <#12/31/2004# and
executing the query yields only blank adddate records.

A couple of notes about the format of the dates. In the VFP tables, when I
browse using VFP, the adddate field shows as mm/dd/yyyy format. When Data
Query views this field, it is in yyyy-mm-dd format. The criteria puts the
date in mm/dd/yyyy format even if I enter it to match the yyyy-mm-dd format.
This behavior happens on both O/S.

I edited the SQL code directly as well to match the format of the displayed
records. Remained unsuccessful.

Any help is greatly appreciated.

Pete

 

[Nick Hodge]

There are not settings in Excel, I was referring to the operating system
regional settings on both, although as you are using US dates, most things
default to that anyway, but worth checking.

remember to shut down and re-open Excel after any change

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[pcrimi]

My operating system regional settings are the same on both PCs.
Pete