I have Sql Server 2000 and Word from Office Xp. Since a few weeks, I cannot
import Data from my database towards a Word document. I follow the
procedure, but at the end, it tells me Word cannot find the data source. If
I use Excel, well it works perfectly. What is the gig?
thanks

Hi

Without an full error message it is very difficult to help. If you are
using exactly the same data source for both then you should not have any
problems.

John

"Fernand St-Georges" <fernand.st-georges@videotron.ca> wrote in message
news:fLi%e.3584$is5.155350@wagner.videotron.net...
>I have Sql Server 2000 and Word from Office Xp. Since a few weeks, I
>cannot import Data from my database towards a Word document. I follow the
>procedure, but at the end, it tells me Word cannot find the data source.
>If I use Excel, well it works perfectly. What is the gig?
> thanks
>

Well I use the same data source, but in Word the error message says
"Word could not open the data source".

*** Sent via Developersdex http://www.developersdex.com ***

Hi

How are you connecting to the data source? If you are using ODBC then you
may want to look at using OLEDB and vice versa. Make sure that you are
typing everything in correctly!

Searching google http://tinyurl.com/7var3 for this did not turn much up!
http://tinyurl.com/d92mx shows you are not the first, but no definite
solution. Using SELECT * seems to be one possible issue.

If using ODBC you may want to try turning on Tracing in the ODBC Data Source
Administrator applet.

HTH

John

"Fernand St-Georges" <fernand.st-georges@videotron.ca> wrote in message
news:TIj%e.39$3S1.11727@news.uswest.net...
>
>
> Well I use the same data source, but in Word the error message says
> "Word could not open the data source".
>
> *** Sent via Developersdex http://www.developersdex.com ***

I'm using OLEDB. I get a good response with Excel, no problem, but with
Word, it srambles. It was not like this before.

Fernand
"John Bell" <jbellnewsposts@hotmail.com> a écrit dans le message de news:
433e484c$0$21316$db0fefd9@news.zen.co.uk...
> Hi
>
> How are you connecting to the data source? If you are using ODBC then you
> may want to look at using OLEDB and vice versa. Make sure that you are
> typing everything in correctly!
>
> Searching google http://tinyurl.com/7var3 for this did not turn much up!
> http://tinyurl.com/d92mx shows you are not the first, but no definite
> solution. Using SELECT * seems to be one possible issue.
>
> If using ODBC you may want to try turning on Tracing in the ODBC Data
> Source Administrator applet.
>
> HTH
>
> John
>
> "Fernand St-Georges" <fernand.st-georges@videotron.ca> wrote in message
> news:TIj%e.39$3S1.11727@news.uswest.net...
>>
>>
>> Well I use the same data source, but in Word the error message says
>> "Word could not open the data source".
>>
>> *** Sent via Developersdex http://www.developersdex.com ***
>
>

Hi

You may want to try using ODBC and see if you have the same problem.

Other things to check are MDAC versions although I would expect this to
be ok.

Have you loaded any office updates or has anything else changed since
it was working?

John


Fernand St-Georges wrote:
> I'm using OLEDB. I get a good response with Excel, no problem, but with
> Word, it srambles. It was not like this before.
>
> Fernand
> "John Bell" <jbellnewsposts@hotmail.com> a écrit dans le message de news:
> 433e484c$0$21316$db0fefd9@news.zen.co.uk...
> > Hi
> >
> > How are you connecting to the data source? If you are using ODBC then you
> > may want to look at using OLEDB and vice versa. Make sure that you are
> > typing everything in correctly!
> >
> > Searching google http://tinyurl.com/7var3 for this did not turn much up!
> > http://tinyurl.com/d92mx shows you are not the first, but no definite
> > solution. Using SELECT * seems to be one possible issue.
> >
> > If using ODBC you may want to try turning on Tracing in the ODBC Data
> > Source Administrator applet.
> >
> > HTH
> >
> > John
> >
> > "Fernand St-Georges" <fernand.st-georges@videotron.ca> wrote in message
> > news:TIj%e.39$3S1.11727@news.uswest.net...
> >>
> >>
> >> Well I use the same data source, but in Word the error message says
> >> "Word could not open the data source".
> >>
> >> *** Sent via Developersdex http://www.developersdex.com ***
> >
> >