Can't establish access database connection from excel

  • Thread starter Thread starter Stephen T
  • Start date Start date
S

Stephen T

I'm trying to write a macro to export records from an
excel form into a database. I can read all about
workspaces and databases in the vb help but the compiler
doesn't understand my code (the procedures aren't in the
library). Using Office XP. Do I need more software or
what? I can do similar things in .asp but not from excel.

Cheers.
 
Hi Stephen,

You'll need to set a reference to whichever library you're writing to.
For most purposes if you're using a Jet (mdb) database file it's
simplest to use the DAO.
 
Back
Top