Excel <-> Access import/export

[Johan Myrberger]

(Working with Office 2000)

I have in the past used Excell as "front application" to retrieve data
from an Access database and work with the data.

What is the easiest way to get Excel data into Access for a specific
task:

I have an Access table with three fields; Customer, Month and Sales.
This will allow me to enter single records as I go...

For "batch" input I'd like to create an input form in a spreadsheet-like
way; Customers listed on One axis, Month on the other and then enter the
Sales in the matrix.

I understand that this is not a "standard" method supported by Access,
but could be solved with some work. My though is that this might be
achieved more easily by importing/exporting the data to Excel. The
import task I have done before, but have not looked at how to get the
modified data back into Access the best way...

Any hints/examples?

Or should I arrange my Access data/tables in some other way? (The
example above is just a subset of what I'd like to achive, in reality
there's more fields in the table)

regards
/Johan Myrberger

 

[Guest]

Easiest way is to link the excel sheet with Access (can via standaard link
(table) procedure) and then fill the table with a query / or VB code.

I build an application with this feature. You can do everything with code
(link tables, import data), but only thing is that you have to ensure that
file name / sheet name / sheet content is always set up in same way
(especially excel sheet).

Another option is to open the excel sheet with code and import code directly
into your tables. But this is more difficult then to link xls sheet and use
query.

Some example on
http://www.mvps.org/access/modules/mdl0006.htm

goodluck,
Eric Wattez