Workflow

Re: Excel-->Infopath--->Sharepoint

Clay Fox — Thu, 12 Jun 2008 14:19:35 GMT

An InfoPath form can query as many sources or times as you want.

I would recommend just exporting the data from excel to SQL and if neccessary use SQL as the data store for the spreadsheet going forward.

That would reduce some complexity. I think what you want to do should be doable.

Re: Excel-->Infopath--->Sharepoint

Franc1 — Thu, 12 Jun 2008 08:59:29 GMT

thank you for your advice.

I have one more question.

In reality before the data being uploaded i have to query a database(MS SQL server) with the datas obtained from the excel file.The result should be displayed in the infopath form AND after send to a sharepoint library in order to be treated by a workflow.

Well my question is how can i query the database for multiple records by using the infopath form?

for example

on input(from the excel file)

line1      first name 1          last name1             adress1          zip1             city1
line2      first name 2          last name2       adress2           zip2             city2
line3      first name 3          last name3             adress3          zip3             city3

....... ............ ................. ......... ..... .....

on output(the answer from the database)

....... ............ ................. ......... ..... .....

Re: Excel-->Infopath--->Sharepoint

Clay Fox — Wed, 11 Jun 2008 17:08:29 GMT

Qdabra has a tool to convert Excel to XML InfoPath documents which then could be used for your data comparison and submit to SharePoint.

You can email their contact email for information.

Excel-->Infopath--->Sharepoint

Franc1 — Wed, 11 Jun 2008 09:02:58 GMT

Hi,

I have several questions:

1 I want to create a form which will "upload" an excel file and extract the data from it.

for example:

First Name Last Name Address City Zip code

Daniel Dubois 42,rue de Chanzy Reims 51100

Olivier Delacroix 32, rue de Carteret Paris 75010

..... ........ ................... ....... ........

...... .......... .................. ........ .......

The data should be displayed by the form and after should be send to an Sharepoint library

2 Once I’ve obtained the extracted data from the form i want to query an access database in order to see if the following contacts exist.

The query answer should be send as well to a Sharepoint library.

This is a schema describing what i'm planning to do.

P.S Please accept my apologise for my bad english

Best Regards,

Filip