C
Craig
I have a complex excel spreadsheet that is used for reporting purposes and
consolidates information from different data sources.
I have 2 data sources, one a SQL Server 2000 database, another is a sybase
SQL Anywhere 9 software.
Each database holds certain information about a unique identifier, let's say
a JobNumber.
I want to populate specific cells within my excel spreadsheet with
information from the data sources, but it's not rows and rows of
information, it is specific field values. What is the best way to achieve
this.
I was thinking of adding a button and using VBA code to retrieve data, but
not sure how this works. Can you point me in the right direction?
Thanks
/ Craig
consolidates information from different data sources.
I have 2 data sources, one a SQL Server 2000 database, another is a sybase
SQL Anywhere 9 software.
Each database holds certain information about a unique identifier, let's say
a JobNumber.
I want to populate specific cells within my excel spreadsheet with
information from the data sources, but it's not rows and rows of
information, it is specific field values. What is the best way to achieve
this.
I was thinking of adding a button and using VBA code to retrieve data, but
not sure how this works. Can you point me in the right direction?
Thanks
/ Craig