Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default how can i export information from an omniform database to excel?

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 694
Default how can i export information from an omniform database to excel?

Hi,
the following document from scansoft:
ftp://ftp.scansoft.com/pub/doc/omnif..._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


"Frenchie" wrote:

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export to database from Excel seth Excel Discussion (Misc queries) 1 December 31st 09 04:37 PM
export information from excel to word doc template Aaron Hodson \(Coversure\) Excel Worksheet Functions 5 January 25th 08 04:40 PM
How do I export information from excel to word, ie database of na. Harry Gill Excel Worksheet Functions 1 April 4th 05 02:25 PM
Database Export to Excel donna Excel Programming 3 February 19th 04 07:16 PM
Export PDF information into Microsoft Excel Brian Excel Programming 0 January 5th 04 09:03 PM


All times are GMT +1. The time now is 05:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"