Excel to Access

[Guest]

How do i have a changing list of data (e.g columns date,name,price) that
changes every day that i can export to access into a datbase. There could be
50 entries one day and 1 the next. macro ?

 

[John Vinson]

On Wed, 29 Mar 2006 15:42:02 -0800, Zygan Condie <Zygan

How do i have a changing list of data (e.g columns date,name,price) that
changes every day that i can export to access into a datbase. There could be
50 entries one day and 1 the next. macro ?

You can use the menu option File... Get External Data... Import from
Access; or you can write VBA code in either an Excel Macro or an
Access Module to run an append query. The details will depend on just
what you want to import (do you want to overwrite existing data?
append data? or what?) and on the structure of your spreadsheet and
your tables.

John W. Vinson[MVP]