Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
External table is not in the expected format
I'm doing a Mailmerge with Word 2007 and Excel 2007 using the new 2007 file
format. My Excel file is password protected so that only I can update it. However, when I try to do a Mailmerge with the Excel file, I receive the following error: External table is not in the expected format. If I take off the password, it works just fine. If I open the Excel file and keep it open while I do a Mailmerge, it works fine. If I save it as a 2003 file format, I get a few error messages, but it still lets me open the Excel file to use in my merge. This process worked just fine in 2003, did something change in 2007? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
External table is not in the expected format
Based on your experience, it would appear that something has changed. Would
setting the read only attribute of the file provide you with sufficient protection against the data being (permanently changed)? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "GHawkins" wrote in message ... I'm doing a Mailmerge with Word 2007 and Excel 2007 using the new 2007 file format. My Excel file is password protected so that only I can update it. However, when I try to do a Mailmerge with the Excel file, I receive the following error: External table is not in the expected format. If I take off the password, it works just fine. If I open the Excel file and keep it open while I do a Mailmerge, it works fine. If I save it as a 2003 file format, I get a few error messages, but it still lets me open the Excel file to use in my merge. This process worked just fine in 2003, did something change in 2007? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
External table is not in the expected format
I assume you mean by doing a right-click, Properties and checking Read-Only?
Not for these files - they are stored on a network share so others can get to them. Those other users also have read/write to the folder, so wouldn't they be able to go in to change that attribute? "Doug Robbins - Word MVP" wrote: Based on your experience, it would appear that something has changed. Would setting the read only attribute of the file provide you with sufficient protection against the data being (permanently changed)? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "GHawkins" wrote in message ... I'm doing a Mailmerge with Word 2007 and Excel 2007 using the new 2007 file format. My Excel file is password protected so that only I can update it. However, when I try to do a Mailmerge with the Excel file, I receive the following error: External table is not in the expected format. If I take off the password, it works just fine. If I open the Excel file and keep it open while I do a Mailmerge, it works fine. If I save it as a 2003 file format, I get a few error messages, but it still lets me open the Excel file to use in my merge. This process worked just fine in 2003, did something change in 2007? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
External table is not in the expected format
Yes, but why would they want to?
-- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "GHawkins" wrote in message ... I assume you mean by doing a right-click, Properties and checking Read-Only? Not for these files - they are stored on a network share so others can get to them. Those other users also have read/write to the folder, so wouldn't they be able to go in to change that attribute? "Doug Robbins - Word MVP" wrote: Based on your experience, it would appear that something has changed. Would setting the read only attribute of the file provide you with sufficient protection against the data being (permanently changed)? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "GHawkins" wrote in message ... I'm doing a Mailmerge with Word 2007 and Excel 2007 using the new 2007 file format. My Excel file is password protected so that only I can update it. However, when I try to do a Mailmerge with the Excel file, I receive the following error: External table is not in the expected format. If I take off the password, it works just fine. If I open the Excel file and keep it open while I do a Mailmerge, it works fine. If I save it as a 2003 file format, I get a few error messages, but it still lets me open the Excel file to use in my merge. This process worked just fine in 2003, did something change in 2007? |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
External table is not in the expected format
In Word 2003, are you using the DDE connection method to connect - i.e.
where Excel will ask you for the password? As far as I know, that's the only way you /can/ open a password-proteced Excel workbook as a mailmerge source, and if so, you will need to do the same thing in 2007 (you have to go to Word Office button-Word Options-Advanced-General and check "Confirm file format conversion on open", then cgo through the connection process again and select DDE when offered. And I have to say that in my experience there are more problems in 2007, e.g. DDE will not even provide the full 255 columns that were possible in an Excel 2003 sheet. -- Peter Jamieson http://tips.pjmsn.me.uk "GHawkins" wrote in message ... I'm doing a Mailmerge with Word 2007 and Excel 2007 using the new 2007 file format. My Excel file is password protected so that only I can update it. However, when I try to do a Mailmerge with the Excel file, I receive the following error: External table is not in the expected format. If I take off the password, it works just fine. If I open the Excel file and keep it open while I do a Mailmerge, it works fine. If I save it as a 2003 file format, I get a few error messages, but it still lets me open the Excel file to use in my merge. This process worked just fine in 2003, did something change in 2007? |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
External table is not in the expected format
Perfect! That's exactly what I was looking for. I forgot about that setting,
thank you so much!! "Peter Jamieson" wrote: In Word 2003, are you using the DDE connection method to connect - i.e. where Excel will ask you for the password? As far as I know, that's the only way you /can/ open a password-proteced Excel workbook as a mailmerge source, and if so, you will need to do the same thing in 2007 (you have to go to Word Office button-Word Options-Advanced-General and check "Confirm file format conversion on open", then cgo through the connection process again and select DDE when offered. And I have to say that in my experience there are more problems in 2007, e.g. DDE will not even provide the full 255 columns that were possible in an Excel 2003 sheet. -- Peter Jamieson http://tips.pjmsn.me.uk "GHawkins" wrote in message ... I'm doing a Mailmerge with Word 2007 and Excel 2007 using the new 2007 file format. My Excel file is password protected so that only I can update it. However, when I try to do a Mailmerge with the Excel file, I receive the following error: External table is not in the expected format. If I take off the password, it works just fine. If I open the Excel file and keep it open while I do a Mailmerge, it works fine. If I save it as a 2003 file format, I get a few error messages, but it still lets me open the Excel file to use in my merge. This process worked just fine in 2003, did something change in 2007? |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
XL 2007 connection string
string strConn =
@"Data Source=D:\Test2.xlsx;Provider=Microsoft.ACE.OLEDB. 12.0; Extended Properties=Excel 12.0;"; |
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
XL 2007 connection string
Are you asking a question? If so, what is it?
-- Peter Jamieson http://tips.pjmsn.me.uk "vijay bandi" wrote in message ... string strConn = @"Data Source=D:\Test2.xlsx;Provider=Microsoft.ACE.OLEDB. 12.0; Extended Properties=Excel 12.0;"; |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select a Single Page (w/format) or Insert pages from external file | Microsoft Word Help | |||
alt 0252 not displaying expected result | Microsoft Word Help | |||
external table of contents | Microsoft Word Help | |||
Shortcut 'Alt O' works not as expected | Microsoft Word Help | |||
When I print a document I get 5 copies instead of the expected 1.. | Microsoft Word Help |