If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
HELLLLLLLLP!! I Need To Pull This Excel File Into Access And... - Sample.xls (1/1)
|
#2
|
|||
|
|||
Well that doesn't give us very much information but do this...
Within an Access database, go to your Tables tab and from the File Menu | Get External Data | Import...choose Excel from your Files of Type, browse and find your Excel file, and follow the prompts. Good Luck... " wrote: |
#3
|
|||
|
|||
OK! Next!
On Thu, 3 Feb 2005 14:27:04 -0800, Micah Chaney wrote: Well that doesn't give us very much information but do this... Within an Access database, go to your Tables tab and from the File Menu | Get External Data | Import...choose Excel from your Files of Type, browse and find your Excel file, and follow the prompts. Good Luck... " wrote: |
#4
|
|||
|
|||
|
#5
|
|||
|
|||
|
#6
|
|||
|
|||
I'm very sorry I didn't realize the rules of this group. Someone here
offered to help walk me through the process when I had all the data. I thought posting a little of of the data would help. I have gone through a five or six Access books and they don't seem to explain the goal that I am trying to attain. They explain each process of Access but none seem to address what I am trying to do. I been searching for months for a template or a program that was set up for this type of thing but that was fruitless.You would think they would do this all over the country for admitting students into the school? Someone here offered to set this up for me for $250 which is too much for me to pay out of my pocket for something for my school. If someone could do it for a more reasonable price I would be happy to pay it. It doesn't seem to be that much to set up but for the life of me I can't figure it out. On Fri, 04 Feb 2005 10:59:55 -0700, John Vinson wrote: On Fri, 04 Feb 2005 01:03:09 GMT, wrote: OK! Next! That was *extremely* rude. Posting your database is completely inappropriate. Binary attachments are NOT welcome in the newsgroups; very few of us will willingly accept a (possibly virus-laden) executable from an unknown source. And just giving us a database to fix without even indicating what specific problem you're having is presumptuous. Please remember - we are NOT Microsoft. We are NOT your paid tech support staff. We are volunteers, donating our time as a public service to help folks learn to use Access. We'll be glad to answer clear and reasonable questions, *posted as text*. We will not (without a consulting contract and a fee) take your database and solve all your problems for you. If you would please post a new thread, *explaining in text what you are trying to do and what specific problem you are having*, one of the volunteers will help if they are willing and able to do so. John W. Vinson[MVP] |
#7
|
|||
|
|||
|
#8
|
|||
|
|||
p.s. Screaming HELLLLLLLLLLP! is going to get you off on the wrong
foot anyway. The volunteers who answer questions here are mostly professionals; a simple description of the problem - e.g. "Importing names and address from Excel" - will be more likely to get you some serious attention. John W. Vinson[MVP] |
#9
|
|||
|
|||
On Fri, 04 Feb 2005 17:33:34 -0700, John Vinson
wrote: On Fri, 04 Feb 2005 22:01:17 GMT, wrote: I have already pulled a list of students into Access (The sample is only part of a list of 1362 students) I have a barcode scanner to scan the student ID number into the computer which I have working. I want to scan the students ID cards with a barcoded ID number and bring up the students name, class and lunch. The Table contains #-Primary Key | Student ID | Last Name | First Name | Grade | HR | Lunch | Class Would I next make up a form containing Student Name (First and Last) Student ID, Lunch and Class in order to pull up these items when I scan the students ID number off of their ID card? I just want to keep scanning one ID after another and not have to reset anything. Is that possible? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
HELLLLLLLLP!! I Need To Pull This Excel File Into Access And... - Sample.xls (0/1) | [email protected] | New Users | 1 | February 18th, 2005 04:29 PM |