Importing XML data from Web Forms

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

Guest

My FrontPage 2003 website has several forms collecting
information entered by customers. I currently download
this data using an FTP utility and then import it into
Access 2003 tables. This data is currently being stored
as text-csv on the Web server.
The Web server support SharePoint Services and I am in
the process of changing these forms to store the data in
XML format rather than text-csv. After this is completed,
can I import this data from the Web server directly into
Access 2003? If this is possible, it will greatly
simplify the complete data capture process by eliminating
the cumbersome FTP utility.
Thanks in advance.
Jim
 
To my knowledge Access2003 can connect directly to SharePoint Services and
link to the tables in it.
I have never done it. I heard it might be slow. Check the Help file and MS
site.
 
Thanks. I will give it a try. If linking works, it is
much better than what I planned to do.
Jim
 
Back
Top