Importing XML data from Web Forms

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
 
J

Joe Fallon

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.
 
G

Guest

Thanks. I will give it a try. If linking works, it is
much better than what I planned to do.
Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top