| Author |
Database Lookup Functoid and Excel Spreadsheet?
|
|
| mike.kolling@gmail.com 2005-09-29, 5:58 pm |
| Hi
I have managed to use the Database Lookup functoid and the extractor to
pull info from SQL Tables.
However has anybody managed to do the same with an Excel spreadsheet?
I have set up a Spreadsheet with same data as I had in a SQL Table and
created a Named range within the Spreadsheet to represent the Table.
I have even got the ConnectionString right (well I assume its right as
it does not exception on it)
I get a result XML file out but it never finds the record to extract
and hence the results file is always blank in that mapped field.
Has anyone ever tried this or does anyone know of any samples out there
that do this?
Thanks in advance
Mike
| |
| carlos 2005-09-30, 7:49 am |
|
Hi mike,
the database lookup use oledb.net to connect to any database, in some
project I used this functoid to query Excel files and all works well without
problems....
I have sent you an example to your email... mike.krolling@gmail.com
"mike.kolling@gmail.com" wrote:
> Hi
>
> I have managed to use the Database Lookup functoid and the extractor to
> pull info from SQL Tables.
>
> However has anybody managed to do the same with an Excel spreadsheet?
>
> I have set up a Spreadsheet with same data as I had in a SQL Table and
> created a Named range within the Spreadsheet to represent the Table.
>
> I have even got the ConnectionString right (well I assume its right as
> it does not exception on it)
>
> I get a result XML file out but it never finds the record to extract
> and hence the results file is always blank in that mapped field.
>
> Has anyone ever tried this or does anyone know of any samples out there
> that do this?
>
> Thanks in advance
>
> Mike
>
>
| |
| mike.kolling@gmail.com 2005-09-30, 5:53 pm |
| Carlos
I think you have sent to the wrong email address, please can you try my
other email: mike.kolling@etcgs.com
Many Thanks
Mike
| |
| carlos medina 2005-09-30, 5:53 pm |
| ok.. I sent the mail to etcgs.com
<mike.kolling@gmail.com> wrote in message
news:1128094389.613842.118770@g43g2000cwa.googlegroups.com...
> Carlos
>
> I think you have sent to the wrong email address, please can you try my
> other email: mike.kolling@etcgs.com
>
> Many Thanks
>
> Mike
>
|
|
|
|