Automatically exporting vantage data into excel

Yahoo Archive
1
Hi Blake,



You need to open MS Query.



In Excel 2003, if I remember correctly, you go to the Data menu and
pick Import External Data, New Database Query, then pick your Vantage
ODBC connection. Enter the system password (probably sysprogress.)



In Excel 2007 you go to the Data menu and pick From Other Sources on the
Get External Data section of the ribbon. Pick From Microsoft Query then
pick your Vantage ODBC connection. Enter the system password.



Then you add the tables you need. Excel will do its best to link the
tables, but you will need to check the links. For example Excel can't
seem to figure out the link from CustNum and it links every table to
every other table. To add a link you just click on the field name in
one table and drag over to the other table.



You pick the fields you want by dragging them down to the section below
where the tables are shown. You can add criteria and sort records.
When you are finished, select File, Return Data to Excel.



The only major drawback to MS Query that I've come across is that it
can't handle more than two tables at a time when you use a left outer
join. If I need to use a lot of left outer joins then I create
multiple queries and use VLookup or Index/Match to link them in the
spreadsheet.



If you know SQL then you can create the SQL query manually by pressing
the SQL button on the MS Query menu.



Hth,

Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Blake Clemens
Sent: Friday, August 28, 2009 9:58 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Automatically exporting vantage data into excel





Linda,

Can you supply some instructions on how to do this?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Linda Lowney
Sent: Friday, August 28, 2009 9:55 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Automatically exporting vantage data into excel

Hello,

Why not use an ODBC connection and create the query that you need right
in Excel?

Regards,

Linda

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Carl Peterson
Sent: Friday, August 28, 2009 9:44 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Automatically exporting vantage data into excel

Hello:

Are you running Progress.

If so, I should be able to help you by writing a Progress program that
would
duplicate your BAQ and output your Excel (delimited?) file to any path
you
want.

We could add an icon to your desktop to run the Progress program to
export
your data. Very easy.

I have worked with Progress for over 20 years and with Vantage customers
since 2006.

Let me know if I can help you. I am located in Michigan.
Carl

Carl Peterson, CPIM
Nexus Software, Inc.
199 N. Main Street - B5
Plymouth, MI 48170
www.nexussoftware.net

Cell: 1-734-812-9532
Office: 1-734-453-3101
Fax: 1-734-455-9550
cpeterson@... <mailto:cpeterson%40nexussoftware.net>
<mailto:cpeterson%40nexussoftware.net>
<mailto:cpeterson%40nexussoftware.net>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
jesh1975
Sent: Tuesday, August 25, 2009 9:45 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Automatically exporting vantage data into excel

Hello all,

I have a problem. We are on version 8.03.408a. in our old 6.1 version
our
shipping girl was able to run a BAQ by herself that would import order
data
into an excel file. This excel file woul then be tied to bartender to
print
barcodes. Anyway. in 8.03 it doesn't save the path for the export file
(i.e
BAQ export process). i know its not hard to do but to type in the path
and
the output file type etc evertime she needs it is ridiculous. I know
about
setting a schedule for it. However there are time when she needs it on
the
fly.

if this makes sense to anyone is there a way to do this. Again its the
typing

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

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

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





[Non-text portions of this message have been removed]
2
Hello all,

I have a problem. We are on version 8.03.408a. in our old 6.1 version our shipping girl was able to run a BAQ by herself that would import order data into an excel file. This excel file woul then be tied to bartender to print barcodes. Anyway. in 8.03 it doesn't save the path for the export file (i.e BAQ export process). i know its not hard to do but to type in the path and the output file type etc evertime she needs it is ridiculous. I know about setting a schedule for it. However there are time when she needs it on the fly.

if this makes sense to anyone is there a way to do this. Again its the typing
3
It's a low tech cludge, but why not just give her a txt file with the BAQ ID, output file path/name & let her copy/paste (or store the BAQ ID, output path/file name in your labelling excel file & copy/paste from that)?


Â



________________________________
From: jesh1975 <jesh1975@...>
To: vantage@yahoogroups.com
Sent: Tuesday, August 25, 2009 9:45:23 AM
Subject: [Vantage] Automatically exporting vantage data into excel

Â
Hello all,

I have a problem. We are on version 8.03.408a. in our old 6.1 version our shipping girl was able to run a BAQ by herself that would import order data into an excel file. This excel file woul then be tied to bartender to print barcodes. Anyway. in 8.03 it doesn't save the path for the export file (i.e BAQ export process). i know its not hard to do but to type in the path and the output file type etc evertime she needs it is ridiculous. I know about setting a schedule for it. However there are time when she needs it on the fly.

if this makes sense to anyone is there a way to do this. Again its the typing







[Non-text portions of this message have been removed]
4
That is an option would work just wanted it to be (hate to say it) but as easy as 6.1 was.


-----
Stanley Machining's website has a new look.
Please visit us at: www.stanleymachining.com

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

Are you running Progress.

If so, I should be able to help you by writing a Progress program that would
duplicate your BAQ and output your Excel (delimited?) file to any path you
want.

We could add an icon to your desktop to run the Progress program to export
your data. Very easy.

I have worked with Progress for over 20 years and with Vantage customers
since 2006.

Let me know if I can help you. I am located in Michigan.
Carl

Carl Peterson, CPIM
Nexus Software, Inc.
199 N. Main Street - B5
Plymouth, MI 48170
www.nexussoftware.net

Cell: 1-734-812-9532
Office: 1-734-453-3101
Fax: 1-734-455-9550
cpeterson@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
jesh1975
Sent: Tuesday, August 25, 2009 9:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Automatically exporting vantage data into excel


Hello all,

I have a problem. We are on version 8.03.408a. in our old 6.1 version our
shipping girl was able to run a BAQ by herself that would import order data
into an excel file. This excel file woul then be tied to bartender to print
barcodes. Anyway. in 8.03 it doesn't save the path for the export file (i.e
BAQ export process). i know its not hard to do but to type in the path and
the output file type etc evertime she needs it is ridiculous. I know about
setting a schedule for it. However there are time when she needs it on the
fly.

if this makes sense to anyone is there a way to do this. Again its the
typing



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



Why not use an ODBC connection and create the query that you need right
in Excel?



Regards,

Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Carl Peterson
Sent: Friday, August 28, 2009 9:44 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Automatically exporting vantage data into excel





Hello:

Are you running Progress.

If so, I should be able to help you by writing a Progress program that
would
duplicate your BAQ and output your Excel (delimited?) file to any path
you
want.

We could add an icon to your desktop to run the Progress program to
export
your data. Very easy.

I have worked with Progress for over 20 years and with Vantage customers
since 2006.

Let me know if I can help you. I am located in Michigan.
Carl

Carl Peterson, CPIM
Nexus Software, Inc.
199 N. Main Street - B5
Plymouth, MI 48170
www.nexussoftware.net

Cell: 1-734-812-9532
Office: 1-734-453-3101
Fax: 1-734-455-9550
cpeterson@... <mailto:cpeterson%40nexussoftware.net>



From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
jesh1975
Sent: Tuesday, August 25, 2009 9:45 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Automatically exporting vantage data into excel


Hello all,

I have a problem. We are on version 8.03.408a. in our old 6.1 version
our
shipping girl was able to run a BAQ by herself that would import order
data
into an excel file. This excel file woul then be tied to bartender to
print
barcodes. Anyway. in 8.03 it doesn't save the path for the export file
(i.e
BAQ export process). i know its not hard to do but to type in the path
and
the output file type etc evertime she needs it is ridiculous. I know
about
setting a schedule for it. However there are time when she needs it on
the
fly.

if this makes sense to anyone is there a way to do this. Again its the
typing

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





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

Can you supply some instructions on how to do this?



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Linda Lowney
Sent: Friday, August 28, 2009 9:55 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Automatically exporting vantage data into excel





Hello,

Why not use an ODBC connection and create the query that you need right
in Excel?

Regards,

Linda

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Carl Peterson
Sent: Friday, August 28, 2009 9:44 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Automatically exporting vantage data into excel

Hello:

Are you running Progress.

If so, I should be able to help you by writing a Progress program that
would
duplicate your BAQ and output your Excel (delimited?) file to any path
you
want.

We could add an icon to your desktop to run the Progress program to
export
your data. Very easy.

I have worked with Progress for over 20 years and with Vantage customers
since 2006.

Let me know if I can help you. I am located in Michigan.
Carl

Carl Peterson, CPIM
Nexus Software, Inc.
199 N. Main Street - B5
Plymouth, MI 48170
www.nexussoftware.net

Cell: 1-734-812-9532
Office: 1-734-453-3101
Fax: 1-734-455-9550
cpeterson@... <mailto:cpeterson%40nexussoftware.net>
<mailto:cpeterson%40nexussoftware.net>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
jesh1975
Sent: Tuesday, August 25, 2009 9:45 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Automatically exporting vantage data into excel

Hello all,

I have a problem. We are on version 8.03.408a. in our old 6.1 version
our
shipping girl was able to run a BAQ by herself that would import order
data
into an excel file. This excel file woul then be tied to bartender to
print
barcodes. Anyway. in 8.03 it doesn't save the path for the export file
(i.e
BAQ export process). i know its not hard to do but to type in the path
and
the output file type etc evertime she needs it is ridiculous. I know
about
setting a schedule for it. However there are time when she needs it on
the
fly.

if this makes sense to anyone is there a way to do this. Again its the
typing

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

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





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