Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Don Sims   on Feb 27 In MS Office Category.

  
Question Answered By: Virgil Foster   on Feb 27

To use an access  DB on your PD, you're going to need the underlying "Jet"
engine, even if you don't have the rest of Access installed. You probably
don't have it installed at the moment.

Why not just change your Office 2003 installation to include Access?

Once the Jet engine is installed on your PC, you can access an mdb database
via a connection and SQL from Excel VBA. You can do most things to it
(including creating and deleting tables), but I have this funny feeling that
you can't actually create  an empty mdb database  via SQL. No problem
though - all you need is an existing mdb file to empty and refill.

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on How To Create Access Database in Excel? Or get search suggestion and latest updates.


Tagged: