How to print rows as Forms or Records

[tmb]

We have a spreadsheet with about 26 columns and and 100 rows.

Each row is a record and we would like to print the entire spreadsheet so
that each row is printed on a page and sorta formated like a Form.

You guys have helped me with the Form View of selected rows.

Anyway to print each row as a form?

thanks for any help.

 

[Earl Kiosterud]

Excel prints sheets they way they're laid out, with a few extras, like
headings, and rows and columns to repeat. That's about it. For a one page
per row layout, you could use Access. You can link the Excel list, and use
an Access Report. Very flexible print layout. You could also use Word mail
merge.

 

[Bill Sharpe]

It's pretty much a kludge, but if you must stick to Excel, try copying
the column headings to the first row of a group of sheets.
Then copy the first record to the second row of the first sheet in the
group.
Select the cells from both rows in the first sheet, click copy.
Select a cell below the first two rows.
Choose Paste Special from the Edit menu, click on Transpose.
You'll see what looks like a form now and you'll probably have to adjust
column widths.

Create a macro to automate the process.

I suspect linking to Access or using Word as another poster suggested is
the better approach.

Bill

We have a spreadsheet with about 26 columns and and 100 rows.

Each row is a record and we would like to print the entire spreadsheet
so
that each row is printed on a page and sorta formated like a Form.

You guys have helped me with the Form View of selected rows.

Anyway to print each row as a form?

thanks for any help.

 

[tmb]

Earl,

How can I "link the Excel list" and use an Access Report?

(I'm not sure what you mean by "Excel list")

Must I export the spreadsheet as a comma delimited or whatever file and
import it into Access?

thanks - tmb

 

[Earl Kiosterud]

tmb,

Excel list is your table. It needs headings, and the rows need to be
contiguous. It should have headings in row 1, or you should have named the
range, so Access can be told where it is.

In Access, once you've started a database, use File - Get external data. If
this is a one-time deal, use Import. If you'll be doing it regularly, use
Link. Change the file type to xls, and navigate to the folder containing
the workbook. Now lay out your Access report, using that table as the data.