Write data from excel to MS-Access using VBA 
Author Message
 Write data from excel to MS-Access using VBA

Is it possible to write data from excel to Access?
I have many macros that execute in xl.  I want to
append data to an existing Access db.

How do you do this.  I would prefer to write to
access without opening it up.

Thanks in advance.

Sent via Deja.com http://www.*-*-*.com/
Before you buy.



Sat, 14 Sep 2002 03:00:00 GMT  
 Write data from excel to MS-Access using VBA
Set a reference to DAO library under Tools | References, and then look in
Help for OpenDatabase, OpenRecordset etc.

 -- Dev

: Is it possible to write data from excel to Access?
: I have many macros that execute in xl.  I want to
: append data to an existing Access db.
:
: How do you do this.  I would prefer to write to
: access without opening it up.
:
: Thanks in advance.
:
:
: Sent via Deja.com http://www.deja.com/
: Before you buy.



Sat, 14 Sep 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. how to connect to ms access through excel, using vba

2. Compatibility Problem Using MS Excel 97 VBA on Excel 2000/XP - Causes crashes

3. MS ACCESS data to MS EXCEL directly

4. Writing an XML file to sharepoint using VBA in excel

5. Edit Access Record in Excel, then send back to Access using VBA

6. Problems updating MS Graph charts in Powerpoint using Excel VBA

7. using vba in MS Excel

8. SendKeys to MS-DOS App using VBA/Excel

9. Running excel add-in (added into excel - not access) in Access VBA

10. Using Data Report Designer in MS Excel?

11. Communicating data between Excel and Project using VBA

12. Excel VBA using ADO to extract data from SQL Server

 

 
Powered by phpBB® Forum Software