Import Customer table into access

It works for 6.1 and 8.X.



The kit is geared for 8.X.



If you are using 6.1 you can use the GUI SQL Explorer tool and should be
able to use the document in the files section of this forum called
Customer_VIEW.doc



Once the view is created you can connect to it through Access.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jasper Recto
Sent: Tuesday, July 29, 2008 3:57 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Import Customer table into access



What version is this resolution for? I'm on version 6.1. I'm not familiar
with the ODBC kit.

________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Ross Hughes
Sent: Tuesday, July 29, 2008 4:00 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Import Customer table into access

Sure. You need to add a SQL view at the server and then it will allow you
to connect to the view.

The detailed instructions are in the document in the ODBC kit.

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
Jasper Recto
Sent: Tuesday, July 29, 2008 2:33 PM
To: Vantage Groups (vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>)
Subject: [Vantage] Import Customer table into access

Has anybody linked the customer table in access?

Jasper Recto
Director of Information Technology
Loc Performance Products, Inc.
734.927.3835

The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.

ITAR Disclaimer
Technical data obtained from Loc through any electronic solicitation are
subject to U.S. Export Control Laws including the International Traffic in
Arms Regulations. Such technical data may not be disclosed to foreign
persons or otherwise exported without first obtaining required U. S.
Government export authorization.

[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]
Has anybody linked the customer table in access?


Jasper Recto
Director of Information Technology
Loc Performance Products, Inc.
734.927.3835

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

ITAR Disclaimer
Technical data obtained from Loc through any electronic solicitation are subject to U.S. Export Control Laws including the International Traffic in Arms Regulations. Such technical data may not be disclosed to foreign persons or otherwise exported without first obtaining required U. S. Government export authorization.




[Non-text portions of this message have been removed]
Sure. You need to add a SQL view at the server and then it will allow you
to connect to the view.



The detailed instructions are in the document in the ODBC kit.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jasper Recto
Sent: Tuesday, July 29, 2008 2:33 PM
To: Vantage Groups (vantage@yahoogroups.com)
Subject: [Vantage] Import Customer table into access



Has anybody linked the customer table in access?

Jasper Recto
Director of Information Technology
Loc Performance Products, Inc.
734.927.3835

The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.

ITAR Disclaimer
Technical data obtained from Loc through any electronic solicitation are
subject to U.S. Export Control Laws including the International Traffic in
Arms Regulations. Such technical data may not be disclosed to foreign
persons or otherwise exported without first obtaining required U. S.
Government export authorization.

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





[Non-text portions of this message have been removed]
What version is this resolution for? I'm on version 6.1. I'm not familiar with the ODBC kit.



________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ross Hughes
Sent: Tuesday, July 29, 2008 4:00 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Import Customer table into access


Sure. You need to add a SQL view at the server and then it will allow you
to connect to the view.

The detailed instructions are in the document in the ODBC kit.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Jasper Recto
Sent: Tuesday, July 29, 2008 2:33 PM
To: Vantage Groups (vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>)
Subject: [Vantage] Import Customer table into access

Has anybody linked the customer table in access?

Jasper Recto
Director of Information Technology
Loc Performance Products, Inc.
734.927.3835

The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.

ITAR Disclaimer
Technical data obtained from Loc through any electronic solicitation are
subject to U.S. Export Control Laws including the International Traffic in
Arms Regulations. Such technical data may not be disclosed to foreign
persons or otherwise exported without first obtaining required U. S.
Government export authorization.

[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]