MSQuery only returning partial fields

[greengo204]

Not sure if ive posted this in the correct forum...Please advise.

I'm trying to return data from an ODBC source using MSQUERY to Excel 2003. There are two tables iv'e joined one containing Customer Information and the other containg Fixed Contract information. The tables are joined by Customer ID.

In MS Query the information looks correct:

A/C_Code A/C_Name Amount Start_DT Name

08ZZZ999 ZZZZ Storage 1000 01/01/2009 00:00:00 Flexible

But when i return the data to Excel only partial fields are returned:

A/C_Code A/C_Name Amount Start_DT Name

08ZZ ZZZZ St 1000 01/01/2009 00:00 Flex


Am i using MSQUERY in the correct way? this is the first time i have used this tool.

Could anyone suggest why this is happening?

Cheers

 

[xlbo]

yup - that'd be about what I would've suggested!

I assume you're getting no issues with truncated strings using this method? ;-)

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[greengo204]

thats correct no issues at all.

Cheers everyone for the help, i thought i was going mental at one point!!

regards