MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How To Create Access Database in Excel?

  Asked By: Don    Date: Feb 27    Category: MS Office    Views: 1438

I have Office 2003 in my Pc installed. But I only choosed Word and Excel to
install. Access is not installed in my Pc. Can i create and manage an Access
(*.mdb) database in Excel VBA? I want to create it and then send/take data and
some simple queries. Is it possible? If possible, how should be the needed code?



3 Answers Found

Answer #1    Answered By: Darrel Nelson     Answered On: Feb 27

Your database  can be done in Excel, but you will need to get some real good
books on Excel VBA.
And look on Microsoft's web site for some Excel samples.
And I am sure some of the members can direct you to other web sites with
examples, etc.

Answer #2    Answered By: Jake Evans     Answered On: Feb 27

You may be able to work with Access via VBA - if you can turn on the
references to Access. I don't have a computer where I can check to see which
references do or do not get loaded depending on the applications installed.

Answer #3    Answered By: Virgil Foster     Answered 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.

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.