HELLLLLLLLP!! I Need To Pull This Excel File Into Access And... - Sample.xls (1/1)

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:

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:

On Fri, 04 Feb 2005 01:03:09 GMT, wrote:

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:

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]

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]

On Fri, 04 Feb 2005 22:01:17 GMT, wrote:

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.

It might have helped if you had said so. You're far from the only
person posting here; most of the volunteers answer dozens to hundreds
of questions a week, and it's possible that the person who asked to
see the data wasn't aware that that's what you were posting. It might
even have been me who answered your previous question; if so, I
apologize, but I've forgotten the details.

Even so, if someone INVITES you to email them your database that's
between the two of you; just posting the database without a question,
explanation, or comment is what I felt was out of line.

Please, post a description of *what you are trying to do*, and a
description (not a data dump) of what you have to work with, and a
specific statement of what problems you're having. We'll do our best
to help you work through it!

John W. Vinson[MVP]

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]

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?

On Sat, 05 Feb 2005 19:18:40 GMT, wrote:

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.

What exactly is in the Lunch field?

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?



A scanner - usually, I'm not certain about yours - is usually
connected to the computer's keyboard port (often using a "y" cable
from the keyboard port to both the scanner and the keyboard). Is that
the case? If so, the computer can't tell whether your scanning or just
typing very fast and accurately.

What you would need to do is to have a Form with textboxes for all of
the information that you want to see; these should all have their
Enabled property set to FALSE and their Locked property to TRUE so
they cannot be overtyped. If you need to change a student's name,
you'll need a different form to do so.

There would be one textbox for the StudentID; let's name it
txtStudentID. It would have its Tab Order property 0, Tab Stop Yes,
and - critical here! - its Control Source property blank. You're not
going to store the scanned ID, only use it to find a record.

In this textbox's AfterUpdate event put the following VBA code. Click
the ... icon by the After Update line on the Events tabl of the
textbox's properties:

Private Sub txtStudentID_AfterUpdate()
Dim rs As DAO.Recordset
Set rs = Me.RecordsetClone ' get the form's list of records
rs.FindFirst "[Student ID] = '" & Me!txtStudentID & "'"
If rs.NoMatch Then ' see if this ID exists
MsgBox "Check this card, this ID was not found", vbOKOnly
Else
Me.Bookmark = rs.Bookmark ' open the found student's record
End If

This will, after you scan or type in the studentID, search the Form's
recordset for the selected student; if they're found their information
will be displayed, if not a message will pop up.

Hope this helps... and my apologies for the tone of the netiquette
lecture!


John W. Vinson[MVP]