Monday, March 12, 2012

ODBC/SQL M$ EXCEL 97 vs XP

Any ideas appreciated...
Users can export to Excel97 but cannot using ExcelXP. Get
error: "unknown token received from sql server"
Have patched SQL & OfficeXP locally to current M$ levels.
ODBC connects no problem.
I'm a tech, not a programmer, so any ideas really
appreciated.
JimmieDExport from what how? More details needed.
-- Mary
MCW Technologies
http://www.mcwtech.com
On Fri, 26 Dec 2003 05:55:00 -0800, "JimmieD"
<anonymous@.discussions.microsoft.com> wrote:
quote:

>Any ideas appreciated...
>Users can export to Excel97 but cannot using ExcelXP. Get
>error: "unknown token received from sql server"
>Have patched SQL & OfficeXP locally to current M$ levels.
>ODBC connects no problem.
>I'm a tech, not a programmer, so any ideas really
>appreciated.
>JimmieD
|||SQL Database using a macro. It appears to download the
info but it looks like right before it displays the data
in EXCELXP, the error appears.
Macro/export functions OK in EXCEL97.
Jim
quote:

>--Original Message--
>Export from what how? More details needed.
>-- Mary
>MCW Technologies
>http://www.mcwtech.com
>On Fri, 26 Dec 2003 05:55:00 -0800, "JimmieD"
><anonymous@.discussions.microsoft.com> wrote:
>
Get[QUOTE]
levels.[QUOTE]
>.
>
|||I think you're going to have a hard time with this one unless you get
a programmer to help you. If you're using an Excel macro, it's written
in VBA. A programmer can help you step through the code to see where
it's failing.
-- Mary
MCW Technologies
http://www.mcwtech.com
On Fri, 26 Dec 2003 08:33:06 -0800, "JimmieD"
<anonymous@.discussions.microsoft.com> wrote:
[QUOTE]
>SQL Database using a macro. It appears to download the
>info but it looks like right before it displays the data
>in EXCELXP, the error appears.
>Macro/export functions OK in EXCEL97.
>Jim
>Get
>levels.

No comments:

Post a Comment