database connectivity

[bhawana]

i have prepared a website in publisher 2003. i want to put requisition form
for book on the website? but doesn't have clue how to store the users
requisition in my database. is there any facility in the publisher so that i
can make a database in excel or access and entries of users can be directly
stored in database.

 

[Spike]

There are several ways to that
I have used one method that works well
Create a form in publisher for users to fill in
When you receive the reply Highlight the text of the message
Paste it into the EXCEL spread sheet in a blank area
It will appear in rows
Highlight the cells and copy
Right click on the next row in the data field where you want the data to go
Select paste special check the transpose box
Select OK
Delete the information in the rows format
Your received data from the email will now be in column format each row will
be a user

Spike