473,795 Members | 3,358 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

word xp

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
5 1310
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******** ***********@wag ner.videotron.n et...
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


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
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.u swest.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
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.u swest.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
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.u swest.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
3539
by: Mike MacSween | last post by:
tblCourses one to many to tblEvents. A course may have an intro workshop (a type of event), a mid course workshop, a final exam. Or any combination. Or something different in the future. At the moment the printed output is usually going to Word. It's turning into an unholy mess, because I'm having to prepare umpteen different Word templates, and the queries that drive them, depending on what events a course has.
3
6131
by: Yohancef Chin | last post by:
Hi, Being fairly new to .NET I am looking for a way to call MS Word from an event on a webform, and after the user is finished save that created document to an SQL Server database. Has anyone done this? Does it seem possible? I followed the instructions from a sample on the Microsoft knowledge base but it only seems to work when creating a VB.NET Windows .EXE, not an VB.NET ASP app.
2
13535
by: Mikey | last post by:
Sample VB .NET source code to create mailing labels or customized letters using MS Word MailMerge This VB .NET source code will start MS Word and call methods and set properties in MS Word to execute a MailMerge to create mailing labels or customized letters. A label name known to MS Word MailMerge mailing label wizard may be used or a template file containing the field names Line1 thru Line5 for each record to be printed. If a...
7
6251
by: Dave | last post by:
Apologies for the newbie question. I have created a vb.net program for my company that is designed to work with Word Templates (about forty of them that we commonly use) that are selected by the user and populated (with info from an Access database) at run-time, then saved as Word documents. The program I have coded works fine -- it does what I need it to do. But it has two problems: (1) it runs very slowly, and (2) it does not seem to...
4
12444
by: etuncer | last post by:
Hello All, I have Access 2003, and am trying to build a database for my small company. I want to be able to create a word document based on the data entered through a form. the real question is this: can Access create the document and place it as an OLE object to the relevant table? Any help is greatly appreciated. Ricky
1
3013
by: beanie | last post by:
i am a c programming beginner and i am trying to Create a concordance of Word Count for a text File in c programming but my code isn't working.please can u help me out.here is my code: #include <stdio.h> #include <ctype.h> #include <string.h> #include <stdlib.h> struct word { struct word *left; /* tree to the left */ struct word *right; /* tree to the right */ char *WORD;
2
4965
by: beanie | last post by:
i am a beginer in c programming and i am trying to Create a Concordance of Word Count for a Text File but my code is not working.pls can anyone helpme out.here is my code: #include <stdio.h> #include <ctype.h> #include <string.h> #include <stdlib.h> struct word { struct word *left; /* tree to the left */ struct word *right; /* tree to the right */ char *WORD;
0
1928
by: alivip | last post by:
I write code to get most frequent words in the file I won't to implement bigram probability by modifying the code to do the following: How can I get every Token (word) and PreviousToken(Previous word) and frequency and probability From text file and put each one in cell in table For example if the text file content is "Every man has a price. Every woman has a price." First Token(word) is "Every" PreviousToken(Previous...
5
2540
by: alivip | last post by:
How can I get every Token (word) and PreviousToken(Previous word) From multube files and frequency of each two word my code is trying to get all single word and double word (every Token (word) and PreviousToken(Previous word)) from multube files and get frequency of both. it can get for single word but double word give error line 50, in most_frequant_word word1+= ' ' + word_list IndexError: list index out of range import...
1
4400
by: dittytwo | last post by:
Hi there The below code works if you don't try to do anything to the word document which is great (Not :D) I am having problems with the context command both text (i.e initial document with no text) or a subsequent addition of text, insert, to the document. as this is going to be used along side other com opened applications Excel power point etc. it needs to work in the self.X orientation as i can get it to work normally see code 2 ...
0
10213
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10163
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10000
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9037
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7538
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6779
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5436
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4113
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2920
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.