Exporting Part Master to xls or csv

Yahoo Archive
1
If you have Excel 2007, you can do an ODBC connection and just pull em into
an excel spreadsheet and then save it as a CSV.

You can use a prior version of excel as well, assuming you have less than
65,536 parts.


----- Original Message -----
From: "idiabos" <idiabos@...>
To: <vantage@yahoogroups.com>
Sent: Wednesday, January 14, 2009 10:34 AM
Subject: [Vantage] Exporting Part Master to xls or csv


> Does anyone know what the easiest way is to export parts from the part
> master to a .exe or csv file?
>
> Thanks
>
>
> ------------------------------------
>
> 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/linksYahoo! Groups Links
>
>
>
2
Does anyone know what the easiest way is to export parts from the part
master to a .exe or csv file?

Thanks
3
Crystal Reports will generate a csv file.



Dale E. Schuerman

Senior Consultant

RAM Software Systems, Inc.

972-669-0763 x233 (voice)

972-669-9603 (fax)

mailto:dale.schuerman@...
<BLOCKED::blocked::mailto:dale.schuerman@...> (email)

http://www.ramsys.com <BLOCKED::blocked::http://www.ramsys.com/>
(website)



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of idiabos
Sent: Wednesday, January 14, 2009 9:35 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Exporting Part Master to xls or csv



Does anyone know what the easiest way is to export parts from the part
master to a .exe or csv file?

Thanks




########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################


[Non-text portions of this message have been removed]
4
BAQ using the BAQ Export process.... export to CSV and then bring into
Excel.

ODBC is another option and Import Data directly into Excel.

If you're SQL, write a query in SQL Enterprise Mgr.




-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of idiabos
Sent: Wednesday, January 14, 2009 10:35 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Exporting Part Master to xls or csv

Does anyone know what the easiest way is to export parts from the part
master to a .exe or csv file?

Thanks


------------------------------------

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/linksYahoo! Groups Links