Hello.

I'm new here and am a total newbie when it comes to office.

I work in a library and have built a meager database to inventory the books, and make it easier for me to to find them on the shelves.

I can perform a search in the DB for book title, author and serial #.

Now I would like to export that books' data to an Excel spreadsheet template that I have already made, and  in certain cells.

I can supply the Excel sheet and the MDB file upon request if necessary.

Thanks!

-Doc

Hi there Doc,

What you are asking here is very simple to do, I'm not sure how to use just access to control excel, but through VB it is very simple.  If you would like I can knock together a simple front end that will shoud allow you to easily search your database and export the information to excel.

I need a few questions answering first though:-

What Windows/Office version are you running?

Do you have VB installed on your system?

What are the directory locations of your .Mdb and .Xls files?

Is this for use on just your PC?

if you want to send me your files, you can send them here:- phil_shotton@hotmail.com

Regards

Shady

____________________________
I don't wanna die... but I ain't keen on livin' either

You can easily PULL information into Excel from your DB too...Goto your Menu->TOOLS->DATA->Import and follow the steps to select you MDB and your Table...its pretty straight forward...

____________________________
Eggheads unite! You have nothing to lose but your yolks.

I have Access 2000.

VB is installed.

For the moment, I have both the .mdb and .xls in the same folder.
c:/../desktop/Bibliotheque/
bibli.mdb
638.xls

Yeahm just on this PC. But it will need to be accessed by 2 different users on this machine.

I aso tried tools/data/import...
My workstation is in French, but under Outils (Tools) I don't have data/import/...
Maybe that's on a different version of office? I have 2000

-Doc

[Edited by DocZayus on 29-03-2004 at 08:57 AM GMT]

I know that from Excel, you may open the database, and easilly import the data in excel.

Even, you can build yourself a search function, in the sheets, with user form.

Daniel B.

____________________________
A Stick give a wise man something to think about... and a fool, something to put in is mouth.