ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Create a Databse using VBA (https://www.excelbanter.com/excel-programming/275133-create-databse-using-vba.html)

Michael Rekas

Create a Databse using VBA
 
Hi there

To create a database to link data from a Pervasive.SQL database to
Excel, I run the CreateDB.exe utility. This is similar to useing the
ODBC manager in the Control Centre.

Apart from clicking next a few times the only user input is the Name
and the Directory.

Is it possible to create the database from within Excel using VBA code
prompting for these 2 variables or getting the info from worksheet
cells.

I would appreciate any help.

Thanks

Michael


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com