Access price Database

[I Am Cdn]

I have a current 15 page Word document (tables)that we publish as our price
list with company logo and page numbers in the header of each page and a one
page table of contents as the 1st page.
There are five columns:
Product code
Description
Inner quantity
Case quantity
Price
Order (a blank for customer to hand write in his order)

The whole document is usaly faxed into us, we key the order into our custom
inventory package that is built on a Pervasive SQL database. All of our
product infor is also in that SQL database but expeorting it is a
nightmare....export to Crystal Report scrfeen print then to Excel, etc.

Our website is a wholeother issue but what we try to do is when we update
the Word document we go in and manually change our website.

Now that we have the Word document accurately reflecting our 978 products
that are in our SQL database we are thinking one MS Access database to drive
a Word hard copy price list and a revamp webpage design.

1. As we are new to Access are we going in the correct direction?
2. Is there a product / price database template out there that we can import
data from Word or Excel or a csv file? (we don't need an inventory management
database...our SQL based program does all that + Cdn payroll)

Thanks

 

[Alex Ivanov]

I am not familiar with Pervasive, but I don't see any reasons why exporting
data is a nightmare.
If you have an ODBC driver to your database, you should be able easily link
the live data to your XL spreadsheet, Access database, or even Word. Don't
export, link instead. In Excel you can run Data/Import External Data/New
database Query command from menu and follow the prompts; in Access -
File/Get External Data/Link tables. Select ODBC databases as your source and
configure the driver if you don't have pre-made ODBC connection, otherwise
choose that.