how do i collect data in an offline form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My problem is that i want to collect product demand forecasts from different
sales people across the globe. In order to achieve this, is there any "form"
like file I can create in either Access or Excel, which I can send over the
email and once I get the form back, I should be able to integrate the data
into one database/excel sheet easily.
 
Build an Excel spreadsheet in a table format then build an Access table that
has the same fields. Send a copy of the spreadsheet to each salesperson to
complete with instructions to email it back to you. When you receive it,
link to the spreadsheet and use an Append Query to add the data to your
Access table. If needed, you could build other append queries that get their
data from this master table and appends the data to other tables that would
make your data normalized.
 
PC Datasheet said:
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1100 users have come to me from the newsgroups requesting help
(e-mail address removed)
Click to expand...

To the original poster:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html (updated)

Arno R
 
Can you wait for the next version of Office? There's not much detail
available yet, but a data collection via e-mail feature has been publicly
announced ...

<quote>
Data collection via email - send an email to co-workers as an InfoPath or
HTML form. The person fills out the form and sends it back. The data is
automatically updated in the database.
</quote>

The above quote is from Erik Rucker's blog ...

http://blogs.msdn.com/access/

If you can't wait, well, Excel files can easily be sent as e-mail
attachments, but you'll have to write custom code to get the data from the
Excel files into the database.
 
Back
Top