By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,652 Members | 1,416 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,652 IT Pros & Developers. It's quick & easy.

word xp

P: n/a
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
Sep 30 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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

Sep 30 '05 #2

P: n/a


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 ***
Sep 30 '05 #3

P: n/a
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 ***

Oct 1 '05 #4

P: n/a
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 ***


Oct 2 '05 #5

P: n/a
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 ***



Oct 3 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.