Home > Data Source > Word Was Unable To Open The Data Source Excel 2010

Word Was Unable To Open The Data Source Excel 2010

Contents

Thank you very much. 0 Message Active 1 day ago Author Comment by:btny ID: 387512462013-01-07 I tested your suggestions but nothing worked. Hope that helps, let me know how you go ...Terry 0 LVL 76 Overall: Level 76 MS Word 65 MS Office 29 MS Excel 20 Message Active today Expert Comment EDIT: I copied a template that works to the same folder as the template giving the issue. This did not work. his comment is here

the pathname may also be saved in various "recently accessed files" type lists, e.g. Your name or email address: Do you already have an account? You'll be able to ask questions about MS Office or chat with the community and help others. the file path, template name, etc.. 3.

Word 2013 Word Was Unable To Open The Datasource

Word always includes certain properties even when they are not strictly necessary. The next time the staff opens the document Word responds with 'Opening this document will run the following SQL Command' - as we would expect - but then we get a Yu still > > need to specify the .odc in the Name parameter and the SQL statement, but > > you may find this works where the other approach does not. Mail Merge - Cannot open data source « Previous Thread | Next Thread » Thread Tools Display Modes #1 December 3rd 09, 07:45 PM posted to microsoft.public.word.docmanagement

So the only things you can do are a. just a rectangular table of data with no formulas etc.) it is probably worth exporting your data to a format such as .csv, then recreating your workbook and re-importing the data. Any ideas? Word 2013 Mail Merge Unable To Open Data Source This second date is the issue.

I copied and pasted the newly created Excel 2010 spreadsheet into the body of the Word document and Beatriz was able to go in and edit the spreadsheet within Word without Word 2016 Was Unable To Open The Data Source Compatibility only goes so far! ...and my last response which is exactly the same as the solution you came across yourself? 0 LVL 16 Overall: Level 16 MS Excel 11 A few questions: a. have any sorts or filters been applied to the data? -- Peter Jamieson http://tips.pjmsn.me.uk "Jane" <[email protected]> wrote in message news:[email protected] On Tuesday, August 21, 2007 7:42 AM Jan wrote: 1.

Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... Mail Merge Can't Open Data Source {{offlineMessage}} Try Microsoft Edge, a fast and secure browser that's designed for Windows 10 Get started Store Store home Devices Microsoft Surface PCs & tablets Xbox Virtual reality Accessories Windows phone The excel file otherwise works normally, as does word itself. However, there could also be problems if Word does not recognise the character encoding of your .csv file correctly - but let's leave that for now.

Word 2016 Was Unable To Open The Data Source

Then, when I select "ok", it tells me that Word is unable to open the data source. Peter Jamieson View Public Profile View message headers Find all posts by Peter Jamieson Find all threads started by Peter Jamieson « Previous Thread | Next Thread » Thread Tools Word 2013 Word Was Unable To Open The Datasource If there are any > > security issues, they will probably appear there. Word Was Unable To Open The Data Source Word 2010 Using http://support.microsoft.com/?kbid=285332 > as a guide, the code is as follows: > > > > private void DoMailMergeToPrinter > ( > object oTemplate, // path\filename of the Word envelope template >

all of this is kind of ridiculous and word should fix this problem. http://webinweb.net/data-source/word-was-unable-to-open-the-data-source-excel-2007.html Privacy Policy Terms and Rules Help Popular Sections Word Outlook Excel Access Connect With Us Log-in Register Contact Us Forum software by XenForo™ ©2010-2014 XenForo Ltd. They do not convert so well to Office 2010. Two of the values in the view are dates. Word Was Unable To Open The Data Source Mac

We cannot save the Word merge file with the correct data source attached. MSOfficeForums.com is not affiliated with Microsoft LinkBack LinkBack URL About LinkBacks how i fixed word 2010 mail merge won't open data file From: Jim Hanson Date: Sat, 18 Sep 2010 Are you looking for the solution to your computer problem? weblink Connect with top rated Experts 14 Experts available now in Live!

The page includes an automatic fix for Word 2010. Kingsoft Writer Cannot Open Data Source Please try the request again. However, when I use a path like \\Studep1.isd.ad.flinders.edu.au\t1\S1\Data\s1accept43\word_us I still get asked to confirm the data source when opening the template but it doesn't recognise this path and asks me to

One thing they do not really mention - and it is related to the same problem that you can have on a network - is that the location plus the file

the path to the data source is longish: \\server\company\word\mhl clients\h\hollowayjane\mailmerge.txt when I tested on the local drive it was short: c:\cis\mailmerge.txt 3. I'm using the same .ODC file anyway, so if it works manually, it should also work when automated. For example (assuming you're still getting the SQL prompt upon opening the document), when the 'Data Link Properties' dialogue pops up, simply add the missing 'x' to the end of the Mail Merge Will Not Open Data Source In the document, either completely or partially, either in clear text if you save as .rtf, .xml or .htm, or in Word's binary format (actually it may be a readable Unicode

I never see the "Confirm Data Source" dialog box. you find the data source. Anyway, if you try putting the file in a folder with a short pathname I think it will always work. check over here One uses getdate(), the other uses a date from a table.

i create a new "make mail merge" document. I received the prompt about whether I wanted to have the feature repaired and I choose Yes, after my PC rebooted and I double-clicked the embedded spreadsheet in the Word 2010 I have previously done, as you mentioned, saving the document as an HTML and then opening it as text. MS Excel Advertise Here 675 members asked questions and received personalized solutions in the past 7 days.

About Us We're a friendly discussion community for Microsoft Office help and support. Peter Jamieson, Sep 26, 2003 #2 Advertisements Todd Guest Hi Peter, Thanks very much for your quick response. nancy4, Dec 14, 2009 #5 slurpee55 Joined: Oct 20, 2004 Messages: 7,837 According to MS, the reasons for this are: * Your data source is not located on your computer--for example, It really is just a couple of function calls - arghhh!

This does not make sense to me. Thanks! James4630, Dec 13, 2009 #2 redoak Gone but never forgotten Joined: Jun 24, 2004 Messages: 6,782 Click "Report" and request your Thread be transferred as mentioned below. {redoak} redoak, Dec MS Excel Creating an Interactive Chart for Marketers in Excel Video by: AnnieCushing This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts

Tech Support Guy is completely free -- paid for by advertisers and donations. The time now is 01:25 PM. - Contact Us - Microsoft Word Forum WordBanter forum home - FAQ - Links - Privacy Statement - Top Powered by vBulletin Version 3.6.4Copyright ©2000 Save &Close, then send the document to Beatriz for checking as suggested by GrahamSkan Let us know how you go ...Terry 0 Message Active 1 day ago Author Comment by:btny If you aren't using integrated security you may need to log on).

With my merge document open in Word 2003 I click Letters and Mailings on the Tools menu, and then click Mail Merge. The Word fix-it didn't work either. Join Now For immediate help use Live now! b.

In particular, you seem to have to use table > > alias names to qualify column names even where it is not strictly necessary. > > b.