Connect with EXCEL
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 106
- Joined: Thu Jun 08, 2006 8:51 am
Connect with EXCEL
Hi,
How can excel be connected with datastage?
Thanks,
Venkat
How can excel be connected with datastage?
Thanks,
Venkat
On your windows platform, quite easily using ODBC and defining a system DSN on your server.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 106
- Joined: Thu Jun 08, 2006 8:51 am
DSN is enough for Excel access.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 106
- Joined: Thu Jun 08, 2006 8:51 am
Could you perhaps rephrase that? You do need to define rows and columns so that the ODBC drivers can detect them and access them; if that is what you are asking.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 106
- Joined: Thu Jun 08, 2006 8:51 am
I can't recall - why don't you try it without predefined columns to see? If it doesn't work you'll have your answer.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 106
- Joined: Thu Jun 08, 2006 8:51 am
ArndW,
I did not create any job using excel. I want to tell the requirements to client to connect excel. That is why i asked these questions. So now I understood from your answer that to connect with excel, DSN should be created and columns also should be defined.
Thanks Arndw to spend your valuable time to me.
Thanks.
I did not create any job using excel. I want to tell the requirements to client to connect excel. That is why i asked these questions. So now I understood from your answer that to connect with excel, DSN should be created and columns also should be defined.
Thanks Arndw to spend your valuable time to me.
Thanks.
-
- Premium Member
- Posts: 51
- Joined: Tue Feb 05, 2002 3:06 pm
One solution we use is to create .csv (comma delimited) text files. Then when the user double clicks on one of these files, .csv is associated with Excel on their PC - so it opens in Excel. The nice thing about this is that we don't have to concern ourselves with what version of Excel the user has and we don't have to mess with different versions of Excel on the server. So, just an idea if you did not already know about it.
- Scott
- Scott
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: