Magic User Group

Magic Wiki-Wakka : UseODBCforExcel

HomePage :: CATEGORIES | Index :: Changes :: Comments :: Search :: Login/Register

Use with Pervasive and ODBC

With this solution you can give btrieve files to Excel.
See also:
PervasiveODBC
PervasiveODBCMaintainDB
PervasiveODBCflexibleDirectory


  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 (SQL)-link tables with Microsoft Query

Screen Shots (German)


Maintain Database
Maintain Database
Maintain Database
Maintain Database
Maintain Database




Categories
CategoryHowTo

There are 2 comments on this page. [Display comments]

Valid XHTML 1.0 Transitional :: Valid CSS :: Powered by Wikka Wakka Wiki trunk
Page was generated in 0.0777 seconds