A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Visio
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

ODBC with Excel in 2003



 
 
Thread Tools Display Modes
  #1  
Old June 25th, 2006, 10:58 AM posted to microsoft.public.visio.general
external usenet poster
 
Posts: n/a
Default ODBC with Excel in 2003

I'm trying to link an org chart's shapes with an excel spreadsheet using the
ODBC function.

I think I've followed all the steps in the Wizard and the help pages but I
just get an error 'can't decrypt data' (or something like that). Can anyone
suggest what I'm doing wrong? Is there maybe something else to set up or
something else I should have installed?


  #2  
Old June 25th, 2006, 02:21 PM posted to microsoft.public.visio.general
external usenet poster
 
Posts: n/a
Default ODBC with Excel in 2003

when playing with odbc, setup is often one of the first missteps. I like to
use Access to test my odbc setups by having it import using the odbc pointer
(not the excel import). When it get's the tables correct I can then move on.
al

"merlin" wrote in message
...
I'm trying to link an org chart's shapes with an excel spreadsheet using
the ODBC function.

I think I've followed all the steps in the Wizard and the help pages but I
just get an error 'can't decrypt data' (or something like that). Can
anyone suggest what I'm doing wrong? Is there maybe something else to set
up or something else I should have installed?



  #3  
Old June 25th, 2006, 09:52 PM posted to microsoft.public.visio.general
external usenet poster
 
Posts: n/a
Default ODBC with Excel in 2003

Although I'm quite proficient with excel, I've never had to use Access so I
would be well out of my depth there.

Are there any common set-up mistakes I might look at?

"Al Edlund" wrote in message
...
when playing with odbc, setup is often one of the first missteps. I like
to use Access to test my odbc setups by having it import using the odbc
pointer (not the excel import). When it get's the tables correct I can
then move on.
al

"merlin" wrote in message
...
I'm trying to link an org chart's shapes with an excel spreadsheet using
the ODBC function.

I think I've followed all the steps in the Wizard and the help pages but
I just get an error 'can't decrypt data' (or something like that). Can
anyone suggest what I'm doing wrong? Is there maybe something else to set
up or something else I should have installed?





  #4  
Old June 26th, 2006, 10:49 PM posted to microsoft.public.visio.general
external usenet poster
 
Posts: n/a
Default ODBC with Excel in 2003

Is your Excel file password protected? The ODBC drivers do not support
encrypted files.

You can also try importing the Excel data in Excel using ODBC. Kind of a
strange use, but it works and you don't need to mess around with Access.

--
Bill Morein
http://blogs.msdn.com/wmorein
Visio
Microsoft Corporation


"merlin" wrote in message
...
Although I'm quite proficient with excel, I've never had to use Access so
I would be well out of my depth there.

Are there any common set-up mistakes I might look at?

"Al Edlund" wrote in message
...
when playing with odbc, setup is often one of the first missteps. I like
to use Access to test my odbc setups by having it import using the odbc
pointer (not the excel import). When it get's the tables correct I can
then move on.
al

"merlin" wrote in message
...
I'm trying to link an org chart's shapes with an excel spreadsheet using
the ODBC function.

I think I've followed all the steps in the Wizard and the help pages but
I just get an error 'can't decrypt data' (or something like that). Can
anyone suggest what I'm doing wrong? Is there maybe something else to
set up or something else I should have installed?






  #5  
Old June 27th, 2006, 08:30 PM posted to microsoft.public.visio.general
external usenet poster
 
Posts: n/a
Default ODBC with Excel in 2003

OK - I'm a bit closer. The encryption error was indeed the file protection
(could have taken forever to find that out).
I'm now getting the error 'There are no tables or views in the data source'.

I created a test excel sheet with a list of data on sheet 1 with a heading
at the top of each column in the top row.
I saved that and closed it.
Then I went in to Visio (it was already open and on a blank sheet)
Org ChartImport Org Chart DataInfo That's already storedODBC compliant
data source
browse to my testfile and select.
Then I get the error.

Help!




"Bill Morein [MSFT]" wrote in message
...
Is your Excel file password protected? The ODBC drivers do not support
encrypted files.

You can also try importing the Excel data in Excel using ODBC. Kind of a
strange use, but it works and you don't need to mess around with Access.

--
Bill Morein
http://blogs.msdn.com/wmorein
Visio
Microsoft Corporation


"merlin" wrote in message
...
Although I'm quite proficient with excel, I've never had to use Access so
I would be well out of my depth there.

Are there any common set-up mistakes I might look at?

"Al Edlund" wrote in message
...
when playing with odbc, setup is often one of the first missteps. I like
to use Access to test my odbc setups by having it import using the odbc
pointer (not the excel import). When it get's the tables correct I can
then move on.
al

"merlin" wrote in message
...
I'm trying to link an org chart's shapes with an excel spreadsheet
using the ODBC function.

I think I've followed all the steps in the Wizard and the help pages
but I just get an error 'can't decrypt data' (or something like that).
Can anyone suggest what I'm doing wrong? Is there maybe something else
to set up or something else I should have installed?








  #6  
Old June 27th, 2006, 09:21 PM posted to microsoft.public.visio.general
external usenet poster
 
Posts: n/a
Default ODBC with Excel in 2003

Consider trying this. Create an orgchart with visio and then export it as
excel. Compare what Visio saves to what you are trying to give it.... Then
see if Visio can import the file that you just saved.

al

"merlin" wrote in message
...
OK - I'm a bit closer. The encryption error was indeed the file protection
(could have taken forever to find that out).
I'm now getting the error 'There are no tables or views in the data
source'.

I created a test excel sheet with a list of data on sheet 1 with a heading
at the top of each column in the top row.
I saved that and closed it.
Then I went in to Visio (it was already open and on a blank sheet)
Org ChartImport Org Chart DataInfo That's already storedODBC compliant
data source
browse to my testfile and select.
Then I get the error.

Help!




"Bill Morein [MSFT]" wrote in message
...
Is your Excel file password protected? The ODBC drivers do not support
encrypted files.

You can also try importing the Excel data in Excel using ODBC. Kind of a
strange use, but it works and you don't need to mess around with Access.

--
Bill Morein
http://blogs.msdn.com/wmorein
Visio
Microsoft Corporation


"merlin" wrote in message
...
Although I'm quite proficient with excel, I've never had to use Access
so I would be well out of my depth there.

Are there any common set-up mistakes I might look at?

"Al Edlund" wrote in message
...
when playing with odbc, setup is often one of the first missteps. I
like to use Access to test my odbc setups by having it import using the
odbc pointer (not the excel import). When it get's the tables correct I
can then move on.
al

"merlin" wrote in message
...
I'm trying to link an org chart's shapes with an excel spreadsheet
using the ODBC function.

I think I've followed all the steps in the Wizard and the help pages
but I just get an error 'can't decrypt data' (or something like that).
Can anyone suggest what I'm doing wrong? Is there maybe something else
to set up or something else I should have installed?










  #7  
Old June 27th, 2006, 10:08 PM posted to microsoft.public.visio.general
external usenet poster
 
Posts: n/a
Default ODBC with Excel in 2003

OK I tried that. It worked fine exporting and importing (except the
subordinate shapes imported and displayed in a different order, how annoying
is that). The excel file looks similar to mine.

This isn't a great surprise because I haven't had trouble importing data
from an excel file, it's the ODBC compliant import function that's causing
an error.

"Al Edlund" wrote in message
...
Consider trying this. Create an orgchart with visio and then export it as
excel. Compare what Visio saves to what you are trying to give it.... Then
see if Visio can import the file that you just saved.

al

"merlin" wrote in message
...
OK - I'm a bit closer. The encryption error was indeed the file
protection (could have taken forever to find that out).
I'm now getting the error 'There are no tables or views in the data
source'.

I created a test excel sheet with a list of data on sheet 1 with a
heading at the top of each column in the top row.
I saved that and closed it.
Then I went in to Visio (it was already open and on a blank sheet)
Org ChartImport Org Chart DataInfo That's already storedODBC compliant
data source
browse to my testfile and select.
Then I get the error.

Help!




"Bill Morein [MSFT]" wrote in message
...
Is your Excel file password protected? The ODBC drivers do not support
encrypted files.

You can also try importing the Excel data in Excel using ODBC. Kind of a
strange use, but it works and you don't need to mess around with Access.

--
Bill Morein
http://blogs.msdn.com/wmorein
Visio
Microsoft Corporation


"merlin" wrote in message
...
Although I'm quite proficient with excel, I've never had to use Access
so I would be well out of my depth there.

Are there any common set-up mistakes I might look at?

"Al Edlund" wrote in message
...
when playing with odbc, setup is often one of the first missteps. I
like to use Access to test my odbc setups by having it import using
the odbc pointer (not the excel import). When it get's the tables
correct I can then move on.
al

"merlin" wrote in message
...
I'm trying to link an org chart's shapes with an excel spreadsheet
using the ODBC function.

I think I've followed all the steps in the Wizard and the help pages
but I just get an error 'can't decrypt data' (or something like
that). Can anyone suggest what I'm doing wrong? Is there maybe
something else to set up or something else I should have installed?












  #8  
Old June 28th, 2006, 12:54 PM posted to microsoft.public.visio.general
external usenet poster
 
Posts: n/a
Default ODBC with Excel in 2003

two things. a.) what you saw with layout using the orgchart wizard is normal
b.) consider changing the name of excel file in your odbc setup to point to
the file that you just created and see if that file works.
al

"merlin" wrote in message
...
OK I tried that. It worked fine exporting and importing (except the
subordinate shapes imported and displayed in a different order, how
annoying is that). The excel file looks similar to mine.

This isn't a great surprise because I haven't had trouble importing data
from an excel file, it's the ODBC compliant import function that's causing
an error.

"Al Edlund" wrote in message
...
Consider trying this. Create an orgchart with visio and then export it as
excel. Compare what Visio saves to what you are trying to give it....
Then see if Visio can import the file that you just saved.

al

"merlin" wrote in message
...
OK - I'm a bit closer. The encryption error was indeed the file
protection (could have taken forever to find that out).
I'm now getting the error 'There are no tables or views in the data
source'.

I created a test excel sheet with a list of data on sheet 1 with a
heading at the top of each column in the top row.
I saved that and closed it.
Then I went in to Visio (it was already open and on a blank sheet)
Org ChartImport Org Chart DataInfo That's already storedODBC
compliant data source
browse to my testfile and select.
Then I get the error.

Help!




"Bill Morein [MSFT]" wrote in message
...
Is your Excel file password protected? The ODBC drivers do not support
encrypted files.

You can also try importing the Excel data in Excel using ODBC. Kind of
a strange use, but it works and you don't need to mess around with
Access.

--
Bill Morein
http://blogs.msdn.com/wmorein
Visio
Microsoft Corporation


"merlin" wrote in message
...
Although I'm quite proficient with excel, I've never had to use Access
so I would be well out of my depth there.

Are there any common set-up mistakes I might look at?

"Al Edlund" wrote in message
...
when playing with odbc, setup is often one of the first missteps. I
like to use Access to test my odbc setups by having it import using
the odbc pointer (not the excel import). When it get's the tables
correct I can then move on.
al

"merlin" wrote in message
...
I'm trying to link an org chart's shapes with an excel spreadsheet
using the ODBC function.

I think I've followed all the steps in the Wizard and the help pages
but I just get an error 'can't decrypt data' (or something like
that). Can anyone suggest what I'm doing wrong? Is there maybe
something else to set up or something else I should have installed?














  #9  
Old July 1st, 2006, 10:00 AM posted to microsoft.public.visio.general
merlin
external usenet poster
 
Posts: 28
Default ODBC with Excel in 2003

OK. I'm crawling closer to cracking this.

I think I understand now that ODBC is a common interface that I have to set
up between two programs - in this case Visio and Excel. The actual process
of setting it up is eluding me.

1) is ODBC an actual file or is it something you do to the excel and/or
visio file?

2) if it's a file then where does it have to go. Can I choose or is there a
special location for it?

3) When I crack this I'll be doing it at work (practising on my laptop at
home at the mo) so can this file be on a network drive or does it have to be
local to my pc on the hard drive (I try to avaiod that). My choice of
network drives are a 'global' shared drive and a 'home' personal drive.

4) will I need administrator rights to achieve this?

Sorry for the volume of questions. This has turned out to be more complex
than expected but I not going to give up on it!



"Al Edlund" wrote in message
...
two things. a.) what you saw with layout using the orgchart wizard is
normal b.) consider changing the name of excel file in your odbc setup to
point to the file that you just created and see if that file works.
al

"merlin" wrote in message
...
OK I tried that. It worked fine exporting and importing (except the
subordinate shapes imported and displayed in a different order, how
annoying is that). The excel file looks similar to mine.

This isn't a great surprise because I haven't had trouble importing data
from an excel file, it's the ODBC compliant import function that's
causing an error.

"Al Edlund" wrote in message
...
Consider trying this. Create an orgchart with visio and then export it
as excel. Compare what Visio saves to what you are trying to give it....
Then see if Visio can import the file that you just saved.

al

"merlin" wrote in message
...
OK - I'm a bit closer. The encryption error was indeed the file
protection (could have taken forever to find that out).
I'm now getting the error 'There are no tables or views in the data
source'.

I created a test excel sheet with a list of data on sheet 1 with a
heading at the top of each column in the top row.
I saved that and closed it.
Then I went in to Visio (it was already open and on a blank sheet)
Org ChartImport Org Chart DataInfo That's already storedODBC
compliant data source
browse to my testfile and select.
Then I get the error.

Help!




"Bill Morein [MSFT]" wrote in message
...
Is your Excel file password protected? The ODBC drivers do not support
encrypted files.

You can also try importing the Excel data in Excel using ODBC. Kind of
a strange use, but it works and you don't need to mess around with
Access.

--
Bill Morein
http://blogs.msdn.com/wmorein
Visio
Microsoft Corporation


"merlin" wrote in message
...
Although I'm quite proficient with excel, I've never had to use
Access so I would be well out of my depth there.

Are there any common set-up mistakes I might look at?

"Al Edlund" wrote in message
...
when playing with odbc, setup is often one of the first missteps. I
like to use Access to test my odbc setups by having it import using
the odbc pointer (not the excel import). When it get's the tables
correct I can then move on.
al

"merlin" wrote in message
...
I'm trying to link an org chart's shapes with an excel spreadsheet
using the ODBC function.

I think I've followed all the steps in the Wizard and the help
pages but I just get an error 'can't decrypt data' (or something
like that). Can anyone suggest what I'm doing wrong? Is there maybe
something else to set up or something else I should have installed?
















  #10  
Old July 1st, 2006, 02:25 PM posted to microsoft.public.visio.general
Al Edlund
external usenet poster
 
Posts: 581
Default ODBC with Excel in 2003

Try this for a start definition
http://msdn.microsoft.com/library/de...bcoverview.asp

odbc (open database connectivity) are programming interfaces to allow access
to different data sources. They are a form of 'driver' and come in different
version depending on the vendors that supply them for their products (ms
generic, excel, access, oracle, db2, etc.).

for other than ms products support odbc drivers often come with the
product.. ms usually ships some basic ones with the operating systems and
office products. You can also check ms downloads for updates.

when network sharing data the two primary security groups are the networking
group (firewalling of application required flows) and data center (user
rights on servers). For this you will have to check in your own organization

"merlin" wrote in message
...
OK. I'm crawling closer to cracking this.

I think I understand now that ODBC is a common interface that I have to
set up between two programs - in this case Visio and Excel. The actual
process of setting it up is eluding me.

1) is ODBC an actual file or is it something you do to the excel and/or
visio file?

2) if it's a file then where does it have to go. Can I choose or is there
a special location for it?

3) When I crack this I'll be doing it at work (practising on my laptop at
home at the mo) so can this file be on a network drive or does it have to
be local to my pc on the hard drive (I try to avaiod that). My choice of
network drives are a 'global' shared drive and a 'home' personal drive.

4) will I need administrator rights to achieve this?

Sorry for the volume of questions. This has turned out to be more complex
than expected but I not going to give up on it!



"Al Edlund" wrote in message
...
two things. a.) what you saw with layout using the orgchart wizard is
normal b.) consider changing the name of excel file in your odbc setup to
point to the file that you just created and see if that file works.
al

"merlin" wrote in message
...
OK I tried that. It worked fine exporting and importing (except the
subordinate shapes imported and displayed in a different order, how
annoying is that). The excel file looks similar to mine.

This isn't a great surprise because I haven't had trouble importing data
from an excel file, it's the ODBC compliant import function that's
causing an error.

"Al Edlund" wrote in message
...
Consider trying this. Create an orgchart with visio and then export it
as excel. Compare what Visio saves to what you are trying to give
it.... Then see if Visio can import the file that you just saved.

al

"merlin" wrote in message
...
OK - I'm a bit closer. The encryption error was indeed the file
protection (could have taken forever to find that out).
I'm now getting the error 'There are no tables or views in the data
source'.

I created a test excel sheet with a list of data on sheet 1 with a
heading at the top of each column in the top row.
I saved that and closed it.
Then I went in to Visio (it was already open and on a blank sheet)
Org ChartImport Org Chart DataInfo That's already storedODBC
compliant data source
browse to my testfile and select.
Then I get the error.

Help!




"Bill Morein [MSFT]" wrote in message
...
Is your Excel file password protected? The ODBC drivers do not
support encrypted files.

You can also try importing the Excel data in Excel using ODBC. Kind
of a strange use, but it works and you don't need to mess around with
Access.

--
Bill Morein
http://blogs.msdn.com/wmorein
Visio
Microsoft Corporation


"merlin" wrote in message
...
Although I'm quite proficient with excel, I've never had to use
Access so I would be well out of my depth there.

Are there any common set-up mistakes I might look at?

"Al Edlund" wrote in message
...
when playing with odbc, setup is often one of the first missteps. I
like to use Access to test my odbc setups by having it import using
the odbc pointer (not the excel import). When it get's the tables
correct I can then move on.
al

"merlin" wrote in message
...
I'm trying to link an org chart's shapes with an excel spreadsheet
using the ODBC function.

I think I've followed all the steps in the Wizard and the help
pages but I just get an error 'can't decrypt data' (or something
like that). Can anyone suggest what I'm doing wrong? Is there
maybe something else to set up or something else I should have
installed?


















 




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 Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Why no XML in Excel 2003 with Office Standard? [email protected] General Discussion 0 April 21st, 2006 10:36 PM
Sharing read-write Excel 2003 files ttt8262 General Discussion 0 April 1st, 2006 09:39 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users 5 October 27th, 2005 03:06 AM
Help in Excel 2003 Charlie Rowe General Discussion 0 June 13th, 2005 04:31 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno General Discussion 2 June 13th, 2005 02:01 PM


All times are GMT +1. The time now is 06:28 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.