Excel to Access

Zygan Condie · March 30th, 2006, 12:42 AM posted to microsoft.public.access.gettingstarted

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 · March 30th, 2006, 01:33 AM posted to microsoft.public.access.gettingstarted

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

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]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem filtering Dates between Access and Excel	Lanstone	Running & Setting Up Queries	1	January 23rd, 2006 11:06 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER	MEGTOM	New Users	5	October 27th, 2005 03:06 AM
Using Excel charts in Access 2003???	PZStraube	General Discussion	0	March 1st, 2005 01:02 PM
Data from Excel to Access		Database Design	2	August 20th, 2004 12:53 PM