If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Importing Excel Spreadsheet Problem
Since upgrading to Excel 2003 I can no longer import an Excel spreadsheet
into Access 97, this worked fine with Excel 2002 When using the import spreadsheet wizard to import my spreadsheet I get an error message "There is no object in this Control" I have tried this with a new db as well as four or my old db's but can not get the spreadsheet to import. Can anyone offer a solution please |
#2
|
|||
|
|||
Steve
I haven't encountered this exact problem, but it sounds like you are describing an "older" version of Access ('97) not being able to understand the file format of a "newer" version of Excel ('03). Have you tried using Excel to "save back" to an earlier version of Excel, then try importing? -- Good luck Jeff Boyce Access MVP "Steve Goodrich" wrote in message ... Since upgrading to Excel 2003 I can no longer import an Excel spreadsheet into Access 97, this worked fine with Excel 2002 When using the import spreadsheet wizard to import my spreadsheet I get an error message "There is no object in this Control" I have tried this with a new db as well as four or my old db's but can not get the spreadsheet to import. Can anyone offer a solution please |
#3
|
|||
|
|||
AFAIK, there weren't any file format changes between Excel 97 and Excel
2003. I have no problems using that same combination (Access 97/Excel 2003) on my laptop (running WinXP Home SP2) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote in message ... Steve I haven't encountered this exact problem, but it sounds like you are describing an "older" version of Access ('97) not being able to understand the file format of a "newer" version of Excel ('03). Have you tried using Excel to "save back" to an earlier version of Excel, then try importing? -- Good luck Jeff Boyce Access MVP "Steve Goodrich" wrote in message ... Since upgrading to Excel 2003 I can no longer import an Excel spreadsheet into Access 97, this worked fine with Excel 2002 When using the import spreadsheet wizard to import my spreadsheet I get an error message "There is no object in this Control" I have tried this with a new db as well as four or my old db's but can not get the spreadsheet to import. Can anyone offer a solution please |
#4
|
|||
|
|||
Hi Jeff
Thanks for the suggestion, tried saving as all Excel versions listed in the save as... box but same error message with each as i say it worked fine with excel 2002 and access 97 Steve "Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote in message ... Steve I haven't encountered this exact problem, but it sounds like you are describing an "older" version of Access ('97) not being able to understand the file format of a "newer" version of Excel ('03). Have you tried using Excel to "save back" to an earlier version of Excel, then try importing? -- Good luck Jeff Boyce Access MVP "Steve Goodrich" wrote in message ... Since upgrading to Excel 2003 I can no longer import an Excel spreadsheet into Access 97, this worked fine with Excel 2002 When using the import spreadsheet wizard to import my spreadsheet I get an error message "There is no object in this Control" I have tried this with a new db as well as four or my old db's but can not get the spreadsheet to import. Can anyone offer a solution please |
#5
|
|||
|
|||
Given Douglas' response, and your trial, you've stumped me. Perhaps one of
the other readers can offer an approach... -- Good luck Jeff Boyce Access MVP "Steve Goodrich" wrote in message ... Hi Jeff Thanks for the suggestion, tried saving as all Excel versions listed in the save as... box but same error message with each as i say it worked fine with excel 2002 and access 97 Steve "Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote in message ... Steve I haven't encountered this exact problem, but it sounds like you are describing an "older" version of Access ('97) not being able to understand the file format of a "newer" version of Excel ('03). Have you tried using Excel to "save back" to an earlier version of Excel, then try importing? -- Good luck Jeff Boyce Access MVP "Steve Goodrich" wrote in message ... Since upgrading to Excel 2003 I can no longer import an Excel spreadsheet into Access 97, this worked fine with Excel 2002 When using the import spreadsheet wizard to import my spreadsheet I get an error message "There is no object in this Control" I have tried this with a new db as well as four or my old db's but can not get the spreadsheet to import. Can anyone offer a solution please |
#6
|
|||
|
|||
Steve stated "can not get the spreadsheet to import". Did you ever try with
a spreadsheet that is not _the_ spreadsheet? -- Duane Hookom MS Access MVP "Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote in message ... Given Douglas' response, and your trial, you've stumped me. Perhaps one of the other readers can offer an approach... -- Good luck Jeff Boyce Access MVP "Steve Goodrich" wrote in message ... Hi Jeff Thanks for the suggestion, tried saving as all Excel versions listed in the save as... box but same error message with each as i say it worked fine with excel 2002 and access 97 Steve "Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote in message ... Steve I haven't encountered this exact problem, but it sounds like you are describing an "older" version of Access ('97) not being able to understand the file format of a "newer" version of Excel ('03). Have you tried using Excel to "save back" to an earlier version of Excel, then try importing? -- Good luck Jeff Boyce Access MVP "Steve Goodrich" wrote in message ... Since upgrading to Excel 2003 I can no longer import an Excel spreadsheet into Access 97, this worked fine with Excel 2002 When using the import spreadsheet wizard to import my spreadsheet I get an error message "There is no object in this Control" I have tried this with a new db as well as four or my old db's but can not get the spreadsheet to import. Can anyone offer a solution please |
#7
|
|||
|
|||
Thinking Out loud Stupid question but are there any VBA Userforms in the
file you are trying to import and if so what "Controls" are available in Excel but not Access? (If any?! - newbie to Access) Mark (InWales) "Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote in message ... Given Douglas' response, and your trial, you've stumped me. Perhaps one of the other readers can offer an approach... -- Good luck Jeff Boyce Access MVP "Steve Goodrich" wrote in message ... Hi Jeff Thanks for the suggestion, tried saving as all Excel versions listed in the save as... box but same error message with each as i say it worked fine with excel 2002 and access 97 Steve "Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote in message ... Steve I haven't encountered this exact problem, but it sounds like you are describing an "older" version of Access ('97) not being able to understand the file format of a "newer" version of Excel ('03). Have you tried using Excel to "save back" to an earlier version of Excel, then try importing? -- Good luck Jeff Boyce Access MVP "Steve Goodrich" wrote in message ... Since upgrading to Excel 2003 I can no longer import an Excel spreadsheet into Access 97, this worked fine with Excel 2002 When using the import spreadsheet wizard to import my spreadsheet I get an error message "There is no object in this Control" I have tried this with a new db as well as four or my old db's but can not get the spreadsheet to import. Can anyone offer a solution please |
#8
|
|||
|
|||
No. Just a simple list
"Mark (InWales)" wrote in message ... Thinking Out loud Stupid question but are there any VBA Userforms in the file you are trying to import and if so what "Controls" are available in Excel but not Access? (If any?! - newbie to Access) Mark (InWales) "Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote in message ... Given Douglas' response, and your trial, you've stumped me. Perhaps one of the other readers can offer an approach... -- Good luck Jeff Boyce Access MVP "Steve Goodrich" wrote in message ... Hi Jeff Thanks for the suggestion, tried saving as all Excel versions listed in the save as... box but same error message with each as i say it worked fine with excel 2002 and access 97 Steve "Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote in message ... Steve I haven't encountered this exact problem, but it sounds like you are describing an "older" version of Access ('97) not being able to understand the file format of a "newer" version of Excel ('03). Have you tried using Excel to "save back" to an earlier version of Excel, then try importing? -- Good luck Jeff Boyce Access MVP "Steve Goodrich" wrote in message ... Since upgrading to Excel 2003 I can no longer import an Excel spreadsheet into Access 97, this worked fine with Excel 2002 When using the import spreadsheet wizard to import my spreadsheet I get an error message "There is no object in this Control" I have tried this with a new db as well as four or my old db's but can not get the spreadsheet to import. Can anyone offer a solution please |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formatting EXCEL spreadsheet onto WORD document | yoyoyooreo | Page Layout | 3 | December 17th, 2004 05:07 PM |
Excel Paste Link - Insert row problem | yoyoyooreo | General Discussion | 1 | December 17th, 2004 04:15 PM |
Link Lanscaped Excel spreadsheet w 14 columns into a word document | macropod | General Discussion | 1 | November 4th, 2004 01:23 PM |
Ctrl+A macro fix for problem in Excel 2003 | David McRitchie | General Discussion | 4 | June 19th, 2004 12:01 PM |
Mail Merge to excel spreadsheet problem | Alex | Mailmerge | 1 | May 25th, 2004 04:07 PM |