Can't establish access database connection from excel

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.
 
J

John Nurick

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy data from one databse tabel to other database table 1
64 bit 28
Exporting Access table using a button click in exce 4
Open an excel spreadsheet and run a macro from Access VB 2
Downloading Access database table into Excel (VB) 5
>> building a sql database from another sql database 2
Runtime error 429... Cannot create Excel Object from Access 5
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Top