Magic User Group

Magic Wiki-Wakka : UseODBCforExcel

HomePage :: CATEGORIES | Index :: Changes :: Comments :: Search :: Login/Register
Most recent edit on 2005-07-18 18:40:58 by NorbertGutscher [add see also]

Additions:




Edited on 2005-07-18 18:37:35 by NorbertGutscher

Additions:
It is also posible to (SQL)-link tables with Microsoft Query

Deletions:
It is also posible to link tables with with Microsoft Query



Edited on 2005-07-18 18:36:55 by NorbertGutscher

Additions:
With this solution you can give btrieve files to Excel.



Edited on 2005-07-18 17:23:10 by NorbertGutscher

Additions:

Screen Shots (German)

Maintain Database
Maintain Database
Maintain Database
Maintain Database
Maintain Database




Edited on 2005-06-29 00:22:05 by GroupsMBM

Additions:
It is also posible to link tables with with Microsoft Query

Deletions:
It is also posible to link tables with with MicrosoftQuery



Edited on 2005-06-29 00:21:33 by GroupsMBM

Additions:
Categories


Deletions:





Edited on 2005-06-28 23:40:08 by NorbertGutscher

Additions:

CategoryHowTo




Oldest known version of this page was edited on 2005-06-28 23:39:02 by NorbertGutscher []
Page view:

Use with Pervasive and ODBC


  1. Create DDFs
  2. Make a ODBC connection
  3. Call Excel
  4. Open a new Excel map
  5. Go to Data/Extern/New Query
  6. Chose the created ODBC database
  7. Chose files and fields
  8. Import to Excel

It is also posible to link tables with with MicrosoftQuery
Valid XHTML 1.0 Transitional :: Valid CSS :: Powered by Wikka Wakka Wiki trunk
Page was generated in 0.1167 seconds