word xp

[Fernand St-Georges]

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

[John Bell]

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" <fe****************@videotron.ca> wrote in message
news:fL*******************@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

[Fernand St-Georges]

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 ***

[John Bell]

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" <fe****************@videotron.ca> wrote in message
news:TI****************@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 ***

[Fernand St-Georges]

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" <jb************@hotmail.com> a écrit dans le message de news:
43***********************@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" <fe****************@videotron.ca> wrote in message
news:TI****************@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 ***

[John Bell]

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" <jb************@hotmail.com> a écrit dans le message de news:
43***********************@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" <fe****************@videotron.ca> wrote in message
news:TI****************@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 ***