dbTalk Databases Forums  

Linking Paradox X3 to MS Excel 2007

comp.databases.paradox comp.databases.paradox


Discuss Linking Paradox X3 to MS Excel 2007 in the comp.databases.paradox forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Chris Hvidsten
 
Posts: n/a

Default Linking Paradox X3 to MS Excel 2007 - 07-13-2009 , 09:02 AM






Hi there.

Just recently, I had to upgrade my version of Office at work from 2003 to
2007, and since then I've had nothing but trouble with a few graphs I'd made
in 2003.

The graphs are fairly simple; Paradox does all the necessary leg work to get
the results I want, and then an Excel spreadsheet reads in the data from the
result table, which then produces the graph.

However, on a few of these now, I've been getting the error message
"External table is not in the expected format." This was never an issue in
2003, and now even trying to create a new spreadsheet in 2007 yields the
same message.

Anyone have any idea what I can do? I'm running the latest version of BDE
and Microsoft JET, so I don't think it's a verison issue.

Thanks in advance for any help.

Reply With Quote
  #2  
Old   
Steven Green
 
Posts: n/a

Default Re: Linking Paradox X3 to MS Excel 2007 - 07-13-2009 , 09:07 AM






"External table is not in the expected format."

that error ususally relates to indexing and sort order.. my best guess is
that your new Jet settings are different from the old ones, if the Paradox
stuff didn't change..


--

Steven Green - Myrtle Beach, South Carolina USA

http://www.OasisTradingPost.com

Oasis Trading Post
- Collectibles and Memorabilia
- Vintage and Custom Lego Creations

Diamond Software Group
- Paradox Sales and Support

Diamond Sports Gems
- Sports Memorabilia and Trading Cards
"Chris Hvidsten" <chrish (AT) simocorp (DOT) com> wrote

Quote:
Hi there.

Just recently, I had to upgrade my version of Office at work from 2003 to
2007, and since then I've had nothing but trouble with a few graphs I'd
made in 2003.

The graphs are fairly simple; Paradox does all the necessary leg work to
get the results I want, and then an Excel spreadsheet reads in the data
from the result table, which then produces the graph.

However, on a few of these now, I've been getting the error message
"External table is not in the expected format." This was never an issue
in 2003, and now even trying to create a new spreadsheet in 2007 yields
the same message.

Anyone have any idea what I can do? I'm running the latest version of BDE
and Microsoft JET, so I don't think it's a verison issue.

Thanks in advance for any help.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.