ODBC Question

Yahoo Archive
1
On a general note, if ou have linked tables into
access and want to report / query on them try to find
out the fields that are indexed and specify those
fields as selection criteria to make use of the index.
--- carl.heeder@... wrote:
---------------------------------

Depends a lot on the size of the table(s). Our
PartTrans queries can take several minutes

But a small hint. If you do a query linking more
than one table and if the tables include the
Company field, then join them too even if you only
have one company. It makes the query run
much faster.

Carl Heeder
ST Inverter America
281-506-3146
Mobile: 281-221-3421
FAX 978-725-3057





"Kathy Hambleton"


<kbh@electronener To:
"Vantage Onelist (E-mail)" <Vantage@...>

gy.com> cc:


Sent by:
Subject: [Vantage] ODBC Question

vantage@Yahoogrou


ps.com








05/16/2005 10:38


AM


Please respond to


vantage












Hello all!

We are in the process of downloading Vantage
information to Access
through an ODBC connection, for those who do this,
what has been your
experience regarding the time it takes to run? Is it
a long wait time?
Minutes opposed to seconds?

Also can anyone recommend a program to automate this
process?

TIA,
Kathy Hambleton
Electron Energy Corporation
717-898-2294
717-898-0660 (fax)


Useful links for the Yahoo!Groups Vantage Board are: (
Note: You must have already linked your
email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for
Report Builder and Crystal Reports and
other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage
services goto:
http://groups.yahoo.com/group/vantage/links


Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

To unsubscribe from this group, send an email
to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the
Yahoo! Terms of Service.





Useful links for the Yahoo!Groups Vantage Board are: (
Note: You must have already linked your email address
to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for
Report Builder and Crystal Reports and other
'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage
services goto:
http://groups.yahoo.com/group/vantage/links



---------------------------------
Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.

______________________________________________________________________
Post your free ad now! http://personals.yahoo.ca
2
I'm an ODBC newbie, so be kind.
I have a 6.1 test system that I'm experimenting with ODBC on.
I have it working fine, and I took out some tables relating to payroll for
the normal odbcuser login.
If I want to include those tables for HR and Payroll do I just create
another user with access to all the tables
Using the sql explorer tool like I did in the ODBC kit instructions?

Any other tips for someone learning odbc from scratch?
I did set the client's to READ UNCOMMITTED, I don't need the DB to be
corrupted!


Thanks,

Jim Moore
MIS System Administrator
General Dynamics - OTS
Anniston, Al. 36207
jmoore@...-ots.com


----------------------------------------------------------------------------
-
"This email message is for the sole use of the intended
recipient(s) and may contain proprietary and/or confidential
information for which such intended recipients(s) may have
an obligation to treat as proprietary. Any unauthorized review,
use, disclosure, or distribution is strictly prohibited. If you are
not the intended recipient, please contact sender by reply
email and destroy all copies of this e-mail."
----------------------------------------------------------------------------
-



[Non-text portions of this message have been removed]
3
Jim:

If you created a report using odbc and you want someone else
to access the report, all you would have to do is:

1) Make sure they have access to payroll in Vantage
(otherwise they would never be able to see the info in the
report)
2) Then setup odbc on their computer to run the report, or
create the executable for them to run.

Did this answer your question? Or did I miss something?

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]On Behalf Of Moore, Jim
(Anniston)
Sent: Thursday, April 28, 2005 12:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC Question


I'm an ODBC newbie, so be kind.
I have a 6.1 test system that I'm experimenting with ODBC
on.
I have it working fine, and I took out some tables
relating to payroll for
the normal odbcuser login.
If I want to include those tables for HR and Payroll do I
just create
another user with access to all the tables
Using the sql explorer tool like I did in the ODBC kit
instructions?

Any other tips for someone learning odbc from scratch?
I did set the client's to READ UNCOMMITTED, I don't need
the DB to be
corrupted!


Thanks,

Jim Moore
MIS System Administrator
General Dynamics - OTS
Anniston, Al. 36207
jmoore@...-ots.com


----------------------------------------------------------
------------------
-
"This email message is for the sole use of the intended
recipient(s) and may contain proprietary and/or
confidential
information for which such intended recipients(s) may have
an obligation to treat as proprietary. Any unauthorized
review,
use, disclosure, or distribution is strictly prohibited.
If you are
not the intended recipient, please contact sender by reply
email and destroy all copies of this e-mail."
----------------------------------------------------------
------------------
-



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: (
Note: You must have already linked your email address to a
yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for
Report Builder and Crystal Reports and other 'goodies',
please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services
goto: http://groups.yahoo.com/group/vantage/links



------------------------------------------------------------
------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.



[Non-text portions of this message have been removed]
4
Ok Thanks,
I think you are asking if I am using CR or RB, I was talking about pulling
the data directly into Excel.
I do have some problems using ODBC and CR, but that is for another time.

Thanks,

Jim Moore
GD-OTS
Anniston, Al.

-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Thursday, April 28, 2005 1:04 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC Question


Jim:

If you created a report using odbc and you want someone else
to access the report, all you would have to do is:

1) Make sure they have access to payroll in Vantage
(otherwise they would never be able to see the info in the
report)
2) Then setup odbc on their computer to run the report, or create the
executable for them to run.

Did this answer your question? Or did I miss something?

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Moore, Jim
(Anniston)
Sent: Thursday, April 28, 2005 12:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC Question


I'm an ODBC newbie, so be kind.
I have a 6.1 test system that I'm experimenting with ODBC
on.
I have it working fine, and I took out some tables
relating to payroll for
the normal odbcuser login.
If I want to include those tables for HR and Payroll do I just create
another user with access to all the tables
Using the sql explorer tool like I did in the ODBC kit instructions?

Any other tips for someone learning odbc from scratch?
I did set the client's to READ UNCOMMITTED, I don't need
the DB to be
corrupted!


Thanks,

Jim Moore
MIS System Administrator
General Dynamics - OTS
Anniston, Al. 36207
jmoore@...-ots.com


----------------------------------------------------------
------------------
-
"This email message is for the sole use of the intended
recipient(s) and may contain proprietary and/or
confidential
information for which such intended recipients(s) may have
an obligation to treat as proprietary. Any unauthorized review,
use, disclosure, or distribution is strictly prohibited.
If you are
not the intended recipient, please contact sender by reply
email and destroy all copies of this e-mail."
----------------------------------------------------------
------------------
-



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: (
Note: You must have already linked your email address to a yahoo id to
enable access. )
(1) To access the Files Section of our Yahoo!Group for
Report Builder and Crystal Reports and other 'goodies',
please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services
goto: http://groups.yahoo.com/group/vantage/links



------------------------------------------------------------
------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
5
Ok, we don't pull directly into excel. I'm not even sure
you can, but I have been wrong before.

What we do is use odbc to create the crystal report and then
export that into excel. This works very well for us.

Has anyone on this list ever dump into excel directly using
odbc? I'd be curious to learn this as well.

Thanks,


M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]On Behalf Of Moore, Jim
(Anniston)
Sent: Thursday, April 28, 2005 1:18 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] ODBC Question


Ok Thanks,
I think you are asking if I am using CR or RB, I was
talking about pulling
the data directly into Excel.
I do have some problems using ODBC and CR, but that is for
another time.

Thanks,

Jim Moore
GD-OTS
Anniston, Al.

-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Thursday, April 28, 2005 1:04 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC Question


Jim:

If you created a report using odbc and you want someone
else
to access the report, all you would have to do is:

1) Make sure they have access to payroll in Vantage
(otherwise they would never be able to see the info in the
report)
2) Then setup odbc on their computer to run the report, or
create the
executable for them to run.

Did this answer your question? Or did I miss something?

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]On Behalf Of
Moore, Jim
(Anniston)
Sent: Thursday, April 28, 2005 12:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC Question


I'm an ODBC newbie, so be kind.
I have a 6.1 test system that I'm experimenting with
ODBC
on.
I have it working fine, and I took out some tables
relating to payroll for
the normal odbcuser login.
If I want to include those tables for HR and Payroll do
I just create
another user with access to all the tables
Using the sql explorer tool like I did in the ODBC kit
instructions?

Any other tips for someone learning odbc from scratch?
I did set the client's to READ UNCOMMITTED, I don't need
the DB to be
corrupted!


Thanks,

Jim Moore
MIS System Administrator
General Dynamics - OTS
Anniston, Al. 36207
jmoore@...-ots.com


--------------------------------------------------------
--
------------------
-
"This email message is for the sole use of the intended
recipient(s) and may contain proprietary and/or
confidential
information for which such intended recipients(s) may
have
an obligation to treat as proprietary. Any unauthorized
review,
use, disclosure, or distribution is strictly prohibited.
If you are
not the intended recipient, please contact sender by
reply
email and destroy all copies of this e-mail."
--------------------------------------------------------
--
------------------
-



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: (
Note: You must have already linked your email address to
a yahoo id to
enable access. )
(1) To access the Files Section of our Yahoo!Group for
Report Builder and Crystal Reports and other 'goodies',
please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage
services
goto: http://groups.yahoo.com/group/vantage/links



----------------------------------------------------------
--
------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: (
Note: You must have
already linked your email address to a yahoo id to enable
access. )
(1) To access the Files Section of our Yahoo!Group for
Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services
goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links









Useful links for the Yahoo!Groups Vantage Board are: (
Note: You must have already linked your email address to a
yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for
Report Builder and Crystal Reports and other 'goodies',
please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services
goto: http://groups.yahoo.com/group/vantage/links



------------------------------------------------------------
------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.



[Non-text portions of this message have been removed]
6
Yes, you can pull vantage data directly into excel using odbc. Although, I
am usually reporting on more complex queries which I create in access and
then link an excel file to this. It is seemless to users b/c when they open
the excel file it refreshes the data automatically through the access query
linked to vantage tables thru odbc (as long as you have it set-up to refresh
automatically - you can disable this also..)

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Manasa Reddy
Sent: April 28, 2005 2:25 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC Question

Ok, we don't pull directly into excel. I'm not even sure
you can, but I have been wrong before.

What we do is use odbc to create the crystal report and then
export that into excel. This works very well for us.

Has anyone on this list ever dump into excel directly using
odbc? I'd be curious to learn this as well.

Thanks,


M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272
7
Sarah:

Do you have instructions on how to:

1) set up the odbc for excel (or is it the same way you set
it up for Crystal)
2) how you pull the data into excel (like a list of parts
and their descriptions)


Thanks,

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]On Behalf Of
sarah.vareschi@...
Sent: Thursday, April 28, 2005 1:28 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC Question


Yes, you can pull vantage data directly into excel using
odbc. Although, I
am usually reporting on more complex queries which I
create in access and
then link an excel file to this. It is seemless to users
b/c when they open
the excel file it refreshes the data automatically through
the access query
linked to vantage tables thru odbc (as long as you have it
set-up to refresh
automatically - you can disable this also..)

-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com] On Behalf Of
Manasa Reddy
Sent: April 28, 2005 2:25 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC Question

Ok, we don't pull directly into excel. I'm not even sure
you can, but I have been wrong before.

What we do is use odbc to create the crystal report and
then
export that into excel. This works very well for us.

Has anyone on this list ever dump into excel directly
using
odbc? I'd be curious to learn this as well.

Thanks,


M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272


Useful links for the Yahoo!Groups Vantage Board are: (
Note: You must have already linked your email address to a
yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for
Report Builder and Crystal Reports and other 'goodies',
please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services
goto: http://groups.yahoo.com/group/vantage/links



------------------------------------------------------------
------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.



[Non-text portions of this message have been removed]
8
Sure. We do it all the time.
You have to use the Data->Import External Data ->New Data Query Menu
From there you should be able to accss your Vantage tables and define a query that will drop
the values back into a spreadsheet.

This query can be defined to renew every time the spreadsheet is reopened.

Carl Heeder
ST Inverter America
281-506-3146
Mobile: 281-221-3421
FAX 978-725-3057



"Manasa Reddy"
<mreddy@crestview-aer To: <vantage@yahoogroups.com>
ospace.com> cc:
Sent by: Subject: RE: [Vantage] ODBC Question
vantage@yahoogroups.c
om


04/28/2005 01:24 PM
Please respond to
vantage






Ok, we don't pull directly into excel. I'm not even sure
you can, but I have been wrong before.

What we do is use odbc to create the crystal report and then
export that into excel. This works very well for us.

Has anyone on this list ever dump into excel directly using
odbc? I'd be curious to learn this as well.

Thanks,


M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]On Behalf Of Moore, Jim
(Anniston)
Sent: Thursday, April 28, 2005 1:18 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] ODBC Question


Ok Thanks,
I think you are asking if I am using CR or RB, I was
talking about pulling
the data directly into Excel.
I do have some problems using ODBC and CR, but that is for
another time.

Thanks,

Jim Moore
GD-OTS
Anniston, Al.

-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Thursday, April 28, 2005 1:04 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC Question


Jim:

If you created a report using odbc and you want someone
else
to access the report, all you would have to do is:

1) Make sure they have access to payroll in Vantage
(otherwise they would never be able to see the info in the
report)
2) Then setup odbc on their computer to run the report, or
create the
executable for them to run.

Did this answer your question? Or did I miss something?

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]On Behalf Of
Moore, Jim
(Anniston)
Sent: Thursday, April 28, 2005 12:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC Question


I'm an ODBC newbie, so be kind.
I have a 6.1 test system that I'm experimenting with
ODBC
on.
I have it working fine, and I took out some tables
relating to payroll for
the normal odbcuser login.
If I want to include those tables for HR and Payroll do
I just create
another user with access to all the tables
Using the sql explorer tool like I did in the ODBC kit
instructions?

Any other tips for someone learning odbc from scratch?
I did set the client's to READ UNCOMMITTED, I don't need
the DB to be
corrupted!


Thanks,

Jim Moore
MIS System Administrator
General Dynamics - OTS
Anniston, Al. 36207
jmoore@...-ots.com


--------------------------------------------------------
--
------------------
-
"This email message is for the sole use of the intended
recipient(s) and may contain proprietary and/or
confidential
information for which such intended recipients(s) may
have
an obligation to treat as proprietary. Any unauthorized
review,
use, disclosure, or distribution is strictly prohibited.
If you are
not the intended recipient, please contact sender by
reply
email and destroy all copies of this e-mail."
--------------------------------------------------------
--
------------------
-



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: (
Note: You must have already linked your email address to
a yahoo id to
enable access. )
(1) To access the Files Section of our Yahoo!Group for
Report Builder and Crystal Reports and other 'goodies',
please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage
services
goto: http://groups.yahoo.com/group/vantage/links



----------------------------------------------------------
--
------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: (
Note: You must have
already linked your email address to a yahoo id to enable
access. )
(1) To access the Files Section of our Yahoo!Group for
Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services
goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links









Useful links for the Yahoo!Groups Vantage Board are: (
Note: You must have already linked your email address to a
yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for
Report Builder and Crystal Reports and other 'goodies',
please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services
goto: http://groups.yahoo.com/group/vantage/links



------------------------------------------------------------
------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your
email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and
other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links


Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
9
Thanks Carl....something new to play with!

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]On Behalf Of
carl.heeder@...
Sent: Thursday, April 28, 2005 2:09 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC Question



Sure. We do it all the time.
You have to use the Data->Import External Data ->New Data
Query Menu
>From there you should be able to accss your Vantage
tables and define a query that will drop
the values back into a spreadsheet.

This query can be defined to renew every time the
spreadsheet is reopened.

Carl Heeder
ST Inverter America
281-506-3146
Mobile: 281-221-3421
FAX 978-725-3057



"Manasa Reddy"
<mreddy@crestview-aer To:
<vantage@yahoogroups.com>
ospace.com> cc:
Sent by:
Subject: RE: [Vantage] ODBC Question
vantage@yahoogroups.c
om


04/28/2005 01:24 PM
Please respond to
vantage






Ok, we don't pull directly into excel. I'm not even sure
you can, but I have been wrong before.

What we do is use odbc to create the crystal report and
then
export that into excel. This works very well for us.

Has anyone on this list ever dump into excel directly
using
odbc? I'd be curious to learn this as well.

Thanks,


M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]On Behalf Of Moore, Jim
(Anniston)
Sent: Thursday, April 28, 2005 1:18 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] ODBC Question


Ok Thanks,
I think you are asking if I am using CR or RB, I was
talking about pulling
the data directly into Excel.
I do have some problems using ODBC and CR, but that is
for
another time.

Thanks,

Jim Moore
GD-OTS
Anniston, Al.

-----Original Message-----
From: Manasa Reddy
[mailto:mreddy@...]
Sent: Thursday, April 28, 2005 1:04 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC Question


Jim:

If you created a report using odbc and you want someone
else
to access the report, all you would have to do is:

1) Make sure they have access to payroll in Vantage
(otherwise they would never be able to see the info in
the
report)
2) Then setup odbc on their computer to run the report,
or
create the
executable for them to run.

Did this answer your question? Or did I miss something?

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]On Behalf Of
Moore, Jim
(Anniston)
Sent: Thursday, April 28, 2005 12:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC Question


I'm an ODBC newbie, so be kind.
I have a 6.1 test system that I'm experimenting with
ODBC
on.
I have it working fine, and I took out some tables
relating to payroll for
the normal odbcuser login.
If I want to include those tables for HR and Payroll
do
I just create
another user with access to all the tables
Using the sql explorer tool like I did in the ODBC kit
instructions?

Any other tips for someone learning odbc from scratch?
I did set the client's to READ UNCOMMITTED, I don't
need
the DB to be
corrupted!


Thanks,

Jim Moore
MIS System Administrator
General Dynamics - OTS
Anniston, Al. 36207
jmoore@...-ots.com


------------------------------------------------------
--
--
------------------
-
"This email message is for the sole use of the
intended
recipient(s) and may contain proprietary and/or
confidential
information for which such intended recipients(s) may
have
an obligation to treat as proprietary. Any
unauthorized
review,
use, disclosure, or distribution is strictly
prohibited.
If you are
not the intended recipient, please contact sender by
reply
email and destroy all copies of this e-mail."
------------------------------------------------------
--
--
------------------
-



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: (
Note: You must have already linked your email address
to
a yahoo id to
enable access. )
(1) To access the Files Section of our Yahoo!Group for
Report Builder and Crystal Reports and other 'goodies',
please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage
services
goto: http://groups.yahoo.com/group/vantage/links



--------------------------------------------------------
--
--
------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email
to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the
Yahoo!
Terms of Service.



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: (
Note: You must have
already linked your email address to a yahoo id to
enable
access. )
(1) To access the Files Section of our Yahoo!Group for
Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage
services
goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links









Useful links for the Yahoo!Groups Vantage Board are: (
Note: You must have already linked your email address to
a
yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for
Report Builder and Crystal Reports and other 'goodies',
please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage
services
goto: http://groups.yahoo.com/group/vantage/links



----------------------------------------------------------
--
------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: (
Note: You must have already linked your
email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for
Report Builder and Crystal Reports and
other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services
goto:
http://groups.yahoo.com/group/vantage/links


Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.





Useful links for the Yahoo!Groups Vantage Board are: (
Note: You must have already linked your email address to a
yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for
Report Builder and Crystal Reports and other 'goodies',
please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services
goto: http://groups.yahoo.com/group/vantage/links



------------------------------------------------------------
------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.



[Non-text portions of this message have been removed]
10
We use Excel to print our customs documents. We use Microsoft Query and ODBC to link to Vantage to pull all the shipping information and the customs HS codes into Excel. The shipper just has to enter the packing slip number.


Linda Lowney
Decoustics Limited


Subject: RE: ODBC Question

Ok, we don't pull directly into excel. I'm not even sure
you can, but I have been wrong before.

What we do is use odbc to create the crystal report and then
export that into excel. This works very well for us.

Has anyone on this list ever dump into excel directly using
odbc? I'd be curious to learn this as well.

Thanks,
M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272
11
Hello all!

We are in the process of downloading Vantage information to Access
through an ODBC connection, for those who do this, what has been your
experience regarding the time it takes to run? Is it a long wait time?
Minutes opposed to seconds?

Also can anyone recommend a program to automate this process?

TIA,
Kathy Hambleton
Electron Energy Corporation
717-898-2294
717-898-0660 (fax)
12
Kathy,

What process are you using to download the info?

Here is what I do. For each Vantage Table involved I create a linked
table in Access. Then I create a Make Table Query for each of those
linked tables including only the fields I want to use for that
application. Running the Make table query will vary depending on the
size of the table and the # of fields you are bringing in, but most
run anywhere from a second or two to 30 seconds for the bigger
tables. You can use filters in the make table query to reduce the #
of records and speed up the process.

Once the data is "downloaded" into Access tables, everything I do
with the information after that is really speedy. It is a great
method of reporting for things that don't need to be "real time". I
use macro's to run the Make Table Queries for my various programs
overnight using a product called Total Visual Agent which is handy
program to use with Access.

I do not try to use the live linked tables for queries or reports,
that can be very slow.

Let me know if you need more info.

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "Kathy Hambleton" <kbh@e...> wrote:
> Hello all!
>
> We are in the process of downloading Vantage information to Access
> through an ODBC connection, for those who do this, what has been
your
> experience regarding the time it takes to run? Is it a long wait
time?
> Minutes opposed to seconds?
>
> Also can anyone recommend a program to automate this process?
>
> TIA,
> Kathy Hambleton
> Electron Energy Corporation
> 717-898-2294
> 717-898-0660 (fax)
13
Kathy,

My experience is that the bigger the database (table), you will be
better off linking the table and extracting the information you want
(i.e. orders that are already closed from 3 years ago you may not need).
The following are the command and its properties that you will need in a
macro to import/link tables:

Action: Transfer Database

Within Action:
Transfer Type: Import or Link depending of what you want.
Database Type: ODBC database
Database name: ODBC;DSN=[Insert name of database used in progress
explorer - usually mfgsys61];HOST=[name of server];PORT=[ODBC port
assigned in progress explorer for ODBC
connections];DB=mfgsys;UID=sysprogress;PWD=[whatever you set up -
usually sysprogress]

If you associate this macro with a button in a form, it will connect to
vantage and bring the information you need. If you link the tables, you
can create with a query what I called "enhanced" tables that contain
information from multiple Vantage tables into one that you could later
manipulate or change without disturbing anything in Vantage. Also, for
security purposes, if you are deploying any Access databases, the user
just need to "push" the button and it is done. You can protect/hide the
macro from the user so no passwords will be revealed. You need to
consider that power users could always get information in Access (one
trick is to press the shift button and double click in the database to
overwrite any internal security - works depending of Access setup)

Good luck!

Mario Aguirre
Lakin General Corporation, Inc.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kathy Hambleton
Sent: Monday, May 16, 2005 10:39 AM
To: Vantage Onelist (E-mail)
Subject: [Vantage] ODBC Question


Hello all!

We are in the process of downloading Vantage information to Access
through an ODBC connection, for those who do this, what has been your
experience regarding the time it takes to run? Is it a long wait time?
Minutes opposed to seconds?

Also can anyone recommend a program to automate this process?

TIA,
Kathy Hambleton
Electron Energy Corporation
717-898-2294
717-898-0660 (fax)


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



________________________________

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
14
I would tend to link the tables and then query /
report on the linked tables via access.

There is no real benefit in terms of importing as
opposed to linking because then you are just using old
data.

What would you like to automate? Once you have linked
a table once you shouldnt have to do it again.

Gavin
--- Kathy Hambleton <kbh@...> wrote:
---------------------------------
Hello all!

We are in the process of downloading Vantage
information to Access
through an ODBC connection, for those who do this,
what has been your
experience regarding the time it takes to run? Is it
a long wait time?
Minutes opposed to seconds?

Also can anyone recommend a program to automate this
process?

TIA,
Kathy Hambleton
Electron Energy Corporation
717-898-2294
717-898-0660 (fax)


Useful links for the Yahoo!Groups Vantage Board are: (
Note: You must have already linked your email address
to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for
Report Builder and Crystal Reports and other
'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage
services goto:
http://groups.yahoo.com/group/vantage/links



---------------------------------
Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.

______________________________________________________________________
Post your free ad now! http://personals.yahoo.ca
15
Depends a lot on the size of the table(s). Our PartTrans queries can take several minutes

But a small hint. If you do a query linking more than one table and if the tables include the
Company field, then join them too even if you only have one company. It makes the query run
much faster.

Carl Heeder
ST Inverter America
281-506-3146
Mobile: 281-221-3421
FAX 978-725-3057



"Kathy Hambleton"
<kbh@electronener To: "Vantage Onelist (E-mail)" <Vantage@...>
gy.com> cc:
Sent by: Subject: [Vantage] ODBC Question
vantage@Yahoogrou
ps.com


05/16/2005 10:38
AM
Please respond to
vantage






Hello all!

We are in the process of downloading Vantage information to Access
through an ODBC connection, for those who do this, what has been your
experience regarding the time it takes to run? Is it a long wait time?
Minutes opposed to seconds?

Also can anyone recommend a program to automate this process?

TIA,
Kathy Hambleton
Electron Energy Corporation
717-898-2294
717-898-0660 (fax)


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your
email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and
other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links


Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.