Need someone to Import Excel into a class directory in Access

[Franksr]

Not knowing access, I need someone to import my excel sheet of names, addresses, etc into an Access form that I could print out for a class reunion directory?



Thank You

[June7]

Is the worksheet data structure very simple? Have you tried setting a link to the worksheet or using the Access import wizard?

Don't print form, print report.

Suggest you study an introductory tutorial book to learn basics.

[Micron]

Why not just format the sheet to look as you want and arrange the data and print the sheet. It sounds like a one-off job that can be done in Excel rather than something you need a database for.

[Franksr]

In my Excel Spreadsheet I have headers going across as: School Name~Current Name~First Name~Address~City~State~Zip~email

I'm not sure how to get them to list vertically like:
First Name
School Name - Current Name
Address
City, State, Zip
email

Any help would be appreciated.

Why not just format the sheet to look as you want and arrange the data and print the sheet. It sounds like a one-off job that can be done in Excel rather than something you need a database for.

[Franksr]

June7, I have tried and created 7 or 8 access databases but I really don't know what I'm doing.

[June7]

Import or link then build a report and arrange the textboxes as you see fit.

How can you have built 7 or 8 Access databases and not know about arranging textboxes on report?

This is still basic Access functionality. A forum is not appropriate medium for learning basics.

[ArviLaanemets]

I'm not sure how to get them to list vertically like:...

In case you need data for all students to be displayed in such way (I can't imagine why somebody will need something like this!):
In Excel, select all your your table and copy it. Then on another sheet, use PasteSpecial Transponse to get datarange, where for every student data is in same column.

In case you need to select specific student and get his/her data in such way, design an Excel report, where from Data Validation list you select student (to get all students listed in Data Validation List, you need a list of all students in separate table - preferably on separate sheet - and a named range containing all student names defined). After you select a student on report sheet, below it all needed info about this student is read from data table using worksheet functions. There are lot of different ways to do this, I'd prefer having 2 (hidden) helper columns in data table. In 1st helper column table rows are numbered (you can use ROW() function for this. In second helper column is row number from 1st helper column for row with student selected for report, and 0 for all others (you can use SUMIFS() function there). To get the rest of info for selected student in report, you use INDEX() function on column with according info and with 2nd parameter calculated as sum of 2nd helper column.