Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Export to database from Excel | Excel Discussion (Misc queries) | |||
export information from excel to word doc template | Excel Worksheet Functions | |||
How do I export information from excel to word, ie database of na. | Excel Worksheet Functions | |||
Database Export to Excel | Excel Programming | |||
Export PDF information into Microsoft Excel | Excel Programming |