Forum Articles
  Welcome back Join CF
You are here You are here: Home | Forum | Athlon XP 2600 vs 3200

You are currently viewing our boards as a guest which gives you limited access to view most of the discussions, articles and other free features. By joining our Virgin Media community you will have full access to all discussions, be able to view and post threads, communicate privately with other members (PM), respond to polls, upload your own images/photos, and access many other special features. Registration is fast, simple and absolutely free so please join our community today.


Welcome to Cable Forum
Go Back   Cable Forum > Computers & IT > General IT Discussion
Register FAQ Community Calendar

Importing Access data into an Excel sheet
Reply
 
Thread Tools
Old 20-09-2004, 20:50   #1
Daniel H
Inactive
 
Daniel H's Avatar
 
Join Date: Jun 2003
Location: Manchester
Posts: 49
Daniel H is an unknown quantity at this point
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?
Daniel H is offline   Reply With Quote
Advertisement
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
Old 21-09-2004, 00:00   #3
punky
Inactive
 
Join Date: Jun 2003
Age: 45
Posts: 14,750
punky has a golden aurapunky has a golden aura
punky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aura
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.
punky is offline   Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


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