Export to Excel, import from Excel, macros?

[conrai1980]

Okay, I am really a beginner. And I need to fullfill the following task. I do not expect ready-to-use code now, but would be very grateful for your advises:

We have an existing Access Database, among others a Customers table. Each account managers in our company is responsible for a certain number of customers. As only a few people may access the database, I got now the task to extend the access database application by the following functionalities:

1. Export the Customers table to several Excel documents (say - generate an excel file for each account manager), so that the account managers can view and change the data of their customers in the Excel file. It would basically be very useful, if those excel files also could somehow be generated well formatted (e.g. with different colors, for a boolean field in the database a Select list over YES and NO in Excel, etc.), but this is not necessarily needed for the beginning.

2. Import the Customers tables (table of every accout manager, with changed values) to Access and thus update the database on the basis of certain cells/rows/colums in the Excel files.

How can I realize these functionalities the best way? Is it possible to do this with Access Macros? Will we probably have to program it with VBA?

Grateful for any tips, samples, links to forums or tutorials etc, which lead me to a better understanding of the task! Thanks very much!!

conrai

 

[mp9]

Take a look at the TransferSpreadsheet action in Macros if you don't want to use VBA.

http://www22.brinkster.com/accessory/

 

[conrai1980]

Thanks for your answer, mp9!

Yet, we are now not going to use, as orgiginally planned, the exported and imported Excel files any more for the update of the database. That wouldnt make so much sense... The whole thing will be web based in the future...

Thanks anyway!