Cable Forum

Cable Forum (https://www.cableforum.uk/board/index.php)
-   General IT Discussion (https://www.cableforum.uk/board/forumdisplay.php?f=19)
-   -   Importing Access data into an Excel sheet (https://www.cableforum.uk/board/showthread.php?t=17735)

Daniel H 20-09-2004 20:50

Importing Access data into an Excel sheet
 
Here's hoping someone can help!

I have an excel spreadsheet which is all formated and has different collumns and tables etc etc.

I also have a database full of data.

Each line of data in the database has a unqiue item no, and on the spreadsheet is a collumn where i need to enter the item no.

What I want to be able to do is enter an item number on each line of the spreadsheet and then the sheet imports some of the details of that record into specified cells automatically.

Is this possible?

greencreeper 20-09-2004 22:46

Re: Importing Access data into an Excel sheet
 
Quote:

Originally Posted by Daniel H
Here's hoping someone can help!

I have an excel spreadsheet which is all formated and has different collumns and tables etc etc.

I also have a database full of data.

Each line of data in the database has a unqiue item no, and on the spreadsheet is a collumn where i need to enter the item no.

What I want to be able to do is enter an item number on each line of the spreadsheet and then the sheet imports some of the details of that record into specified cells automatically.

Is this possible?

Yes it's possible - you need a VBA programmer though :) Entering the data in Excel would trigger an event than retrieves the information from Access. I should imagine it's complicated - VBA usually is.

punky 21-09-2004 00:00

Re: Importing Access data into an Excel sheet
 
It would help if you periodically export the Access data, into a CSV file. You can then import this into an Excel sheet inside yours, but on another page. Then you can just use the LookupTable function in Excel, which should make life a lot easier.


All times are GMT. The time now is 05:41.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2026, vBulletin Solutions Inc.
All Posts and Content are © Cable Forum