Macro to store excel list in Access d/b

  • Thread starter Thread starter Aj
  • Start date Start date
A

Aj

I need some vba code triggered by a button to store a list
of data in an access table. i have been able to do the
same in another excel sheet, but i'm not sure how to
create a d/b table from VBA. I use Excel 2000
 
Aj

Your description is a little vague, but can you not link the excel 'table'
with Access (File>Get External Data>link tables?

This way you have a live update of Access and can run timed queries, etc on
the 'live' data

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top