I have an access database of employee information that I am querying into Excel 2000 and reformating it so that we can print one page per employee with their vital information and availability. I tried using Access to print reports but I'm overwhelmed with access and don't understand a thing.

I created a macro to import the data and organized it with one employee per row.

John Smith 0055112 1111 Pacific Ave. Bellingham WA 98225 3601112345 Weeknights Weekdays Weekends
Suzie Que 2233421 2222 Atlantic St. Bellingham WA 98226 3602224567 Weekdays Weekends
etc.

I then have a form that looks at each row and displays one row at a time on the form. I created a button on the form for back/forward and if you press forward the form will update with the next employee's information.

I have a print button on the form that is a for/next loop and prints the first record, then goes to the next row and prints that form, then the next row and prints, etc. I have not had opportunity to fully test the printing feature yet, but my concern is that it will be very time consuming to for/next through 600+ employees and print each page one at a time.

Is there a way to create a report (vs. the form I have) that will import all the employees information keeping the same format? There are not enough rows in excel for me to just reformat the rows and columns and create a page for each row. I hope this makes sense. Thanks for any help you can provide.