Main Page | Report this Page
Computers Forum Index  »  Computer - Databases - Paradox  »  Linking Paradox X3 to MS Excel 2007...
Page 1 of 1    

Linking Paradox X3 to MS Excel 2007...

Author Message
Chris Hvidsten...
Posted: Mon Jul 13, 2009 6:02 pm
Guest
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.
 
Steven Green...
Posted: Mon Jul 13, 2009 6:07 pm
Guest
"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 (no spam) simocorp.com> wrote in message
news:4a5b3eb7$1 at (no spam) pnews.thedbcommunity.com...
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.
 
 
Page 1 of 1    
All times are GMT
The time now is Mon Nov 30, 2009 8:25 pm