View Single Post
Old 20-09-2004, 22:46   #2
greencreeper
Inactive
 
Join Date: Nov 2003
Location: Leeds - the dog house
Age: 49
Services: Email me for a current price list
Posts: 8,270
greencreeper has a nice shiny stargreencreeper has a nice shiny stargreencreeper has a nice shiny stargreencreeper has a nice shiny stargreencreeper has a nice shiny star
greencreeper has a nice shiny stargreencreeper has a nice shiny stargreencreeper has a nice shiny stargreencreeper has a nice shiny stargreencreeper has a nice shiny stargreencreeper has a nice shiny stargreencreeper has a nice shiny stargreencreeper has a nice shiny stargreencreeper has a nice shiny stargreencreeper has a nice shiny stargreencreeper has a nice shiny stargreencreeper has a nice shiny stargreencreeper has a nice shiny stargreencreeper has a nice shiny stargreencreeper has a nice shiny stargreencreeper has a nice shiny stargreencreeper has a nice shiny stargreencreeper has a nice shiny stargreencreeper has a nice shiny star
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.
greencreeper is offline   Reply With Quote