I appreciate all of the responses, on- and off-list ... very useful, and I think I have determined how best to move forward. I forgot that the DMT export was still a pipe dream (unless the new version set for E10 actually does it ... sorry: could not attend Insights).
Thanks and regards ...
Shaun Scott | SWMS
Just curious about the best (recommended) way to export (to Excel?) the parts master (or every part description) via v. 9.05 702A … was considering DMT vs. a BAQ, considering the obvious length and number of values. Any suggestions appreciated, in advance.
Shaun Scott | SWMS
Senior Systems Analyst
Information (including any attachments) contained in this electronic transmission is a PRIVILEGED AND CONFIDENTIAL COMMUNICATION. It is for the sole use of the sender and the entity named above. If you received this electronic transmission in error, you are required to immediately delete it in its entirety without making a copy. Further dissemination is absolutely prohibited. Thank you.
Dmt won't export anything. You're relegated to either a BAQ or direct dump from SQL
Sent from my Android phone using TouchDown (www.nitrodesk.com)
-----Original Message-----
From: Shaun W M Scott shaun.scott@… [vantage] [vantage@yahoogroups.com]
Received: Wednesday, 10 Jun 2015, 11:38
Subject: [Vantage] Parts Master - export
Just curious about the best (recommended) way to export (to Excel?) the parts master (or every part description) via v. 9.05 702A … was considering DMT vs. a BAQ, considering the obvious length and number of values. Any suggestions appreciated, in advance.
Shaun Scott | SWMS
Senior Systems Analyst
Information (including any attachments) contained in this electronic transmission is a PRIVILEGED AND CONFIDENTIAL COMMUNICATION. It is for the sole use of the sender and the entity named above. If you received this electronic transmission in error, you are required to immediately delete it in its entirety without making a copy. Further dissemination is absolutely prohibited. Thank you.
Or if you're SQL, right click on database in SQL manager tasks/export data wizard..
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, June 10, 2015 11:39 AM
Subject: [Vantage] Parts Master - export
Just curious about the best (recommended) way to export (to Excel?) the parts master (or every part description) via v. 9.05 702A ... was considering DMT vs. a BAQ, considering the obvious length and number of values. Any suggestions appreciated, in advance.
Shaun Scott | SWMS
Senior Systems Analyst
Information (including any attachments) contained in this electronic transmission is a PRIVILEGED AND CONFIDENTIAL COMMUNICATION. It is for the sole use of the sender and the entity named above. If you received this electronic transmission in error, you are required to immediately delete it in its entirety without making a copy. Further dissemination is absolutely prohibited. Thank you.
[Non-text portions of this message have been removed]
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, June 10, 2015 11:39 AM
Subject: [Vantage] Parts Master - export
Just curious about the best (recommended) way to export (to Excel?) the parts master (or every part description) via v. 9.05 702A ... was considering DMT vs. a BAQ, considering the obvious length and number of values. Any suggestions appreciated, in advance.
Shaun Scott | SWMS
Senior Systems Analyst
Information (including any attachments) contained in this electronic transmission is a PRIVILEGED AND CONFIDENTIAL COMMUNICATION. It is for the sole use of the sender and the entity named above. If you received this electronic transmission in error, you are required to immediately delete it in its entirety without making a copy. Further dissemination is absolutely prohibited. Thank you.
[Non-text portions of this message have been removed]
I think I would use Excel and select the SQL Db and table as the datasource (ODBC fashion). It will open the table directly into a spreadsheet. If you need it portable then select everything and cut/paste values to another sheet.
-Todd C.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, June 10, 2015 11:39 AM
Subject: [Vantage] Parts Master - export
Just curious about the best (recommended) way to export (to Excel?) the parts master (or every part description) via v. 9.05 702A … was considering DMT vs. a BAQ, considering the obvious length and number of values. Any suggestions appreciated, in advance.
Shaun Scott | SWMS
Senior Systems Analyst
Information (including any attachments) contained in this electronic transmission is a
PRIVILEGED AND CONFIDENTIAL COMMUNICATION. It is for the sole use of the sender and the entity named above. If you received this electronic transmission in error, you are required to immediately delete it in its entirety without making a copy.
Further dissemination is absolutely prohibited. Thank you.