Excel to Access

Z

Zygan Condie

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

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 ?
Click to expand...

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]
 
Top