Using access data in a catalog?

B

Bradley Elder

We are trying to produce a catalog of several hundred
products. We have these products in an access database
with model#, description, price and a jpg but we want
output that is much more attractive than what access puts
out. The items are constantly being updated as far as new
products, pricing, model numbers, etc. Is it possible to
output the data to publisher, PageMaker layout or some
other, more graphically attractive page layout software?
Ideally I'd like to just run an attractive report out of
access that allows for graphics, page by page layout,
etc. The other option would be to link through ODBC, OLE
or run an update on fields in the layout software.

We'd also like to output this in PDF for web and cd's.
Any other ideas on how we could publish an attractive
catalog from access data?
 
D

David de Leon

You might want to cycle through your records using DAO or
ADO and produce a web page for each record. This assumes
you know HTML (which is easy to learn). Access can create
web pages based on data (called Data Access Pages), but I
don't find them to be attractive.

David
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top