how can i export information from an omniform database to excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a database created through omniform 5.0 from scansoft, however i was
wondering if it was possible to export those data i have from omniform to
excel. if there is a way, let me know.

thanx a bunch
 
Hi,
the following document from scansoft:
ftp://ftp.scansoft.com/pub/doc/omniform/datasheet_OF5Retail.pdf
says: "Put your data to work by exporting to any ODBC compliant database..."

That is, since you say yuou have a database, you just need to know what type
of db it is and make a query through Excel. Assuming it is an MS Access
database:
-in a new sheet, go to menu Data > Get(or Import) External Data > New
Database Query, the Data Source should pop up.
- Choose MS Access Database, click OK, then browse to the db file.
- Follow the wizzard to make the query. At the end you'll be prompted to
'Return Data to Excel'. click OK --> the query runs and data are returned to
the sheet.
Note: now if you right click on the data, you 'll get additional options
such as Refreshe/Update the data.

If you are interested in summarizing the data into a report, you can use a
Pivot Table instead: menu Data > Picvot Table, and choose External Data
Source instead as the default/usual Excel Range. Then, before being sent to
the Pivot wizard, you'll have to go through the same steps as above to
connect through the data source.

Regards,
Sébastien
<http://www.ondemandanalysis.com>
 
Back
Top