Re: Witango-Talk: Pervasive SQL and MS Access

[Rick Sanders]

Title: Dynamicly change the operand in a select action.

Hi Aseem,   I do this quite alot.   In Access, create a new blank database. Next, go to File > Get external Data > Import tables. Choose ODBC datasources as the filetype! (Naturally your Pervasive database has to be set up in the ODBC.) Choose the Pervasive SQL database you want to use for importing the structure. Then, the wizard will ask you which tables you want to import.   N.B: MS Access doesn't have all the same supported fields as Pervasive SQL. So, if you have a double field or a float field type, MS Access will try to make it a numeric field.   Rick Sanders   Hi, Is there a way I can export the database structure of a database in pervasive SQL to MS Access database?   Please help.