Hello Betty,
Do you need to upload the file just once, or every user need to upload his
file? Here is an article about how to upload a file in ASP applicaiton:
How to upload files to a Web server by using ASP
http://support.microsoft.com/default.aspx/kb/299692
It use an ActiveX control which can easy be created in Visual Basic 6.0.
(If you need solution with ASP.NET, you may refer to:
http://support.microsoft.com/kb/323246)
After you upload the excel file onto the server, you may retrieve the data
from it with JET:
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\ExcelFile.xls;" & _
"Extended Properties=""Excel 8.0;HDR=Yes;"";"
How To Query and Update Excel Data Using ADO From ASP
http://support.microsoft.com/default.aspx/kb/195951
Sincerely,
Luke Zhang
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.