R
Ruth
I am trying to set up a Word web form for customer to fill in registration
information, the info will then be saved in a spreadsheet file on a server,
accessed by IE through specified web address. I keep an Access database of
registrations processed and I would like to import the spreadsheet into the
database weekly for processing,tracking and reporting purposes. Is it
possible to set up a macro to go out to this address and import the data, and
delete the imported data? If so, is there a spreadsheet file format that
would be best for importing and also be something the person designing the
word web form could save the data as?
information, the info will then be saved in a spreadsheet file on a server,
accessed by IE through specified web address. I keep an Access database of
registrations processed and I would like to import the spreadsheet into the
database weekly for processing,tracking and reporting purposes. Is it
possible to set up a macro to go out to this address and import the data, and
delete the imported data? If so, is there a spreadsheet file format that
would be best for importing and also be something the person designing the
word web form could save the data as?