View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Rekas Michael Rekas is offline
external usenet poster
 
Posts: 1
Default 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