[thelist] Converting an Excel file
Veronica Yuill
thelist at lists.evolt.org
Mon Feb 25 10:51:00 2002
At 11:46 25/02/2002 -0500, you wrote:
>Hi,
>
>A client wants to use some information stored in an Excel file in his
>site (ASP).
>Is there a way to convert the Excel file into an Access db table without
>having to input the whole content manually?
I'm pretty sure you can connect to the Excel file directly using ADO tho'
I've never done it myself. Have a look at this KB article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q195951
-- it should help.
HTH
Veronica Yuill email: veronicay@archetype-it.com
Archetype Information Technology Ltd http://www.archetype-it.com/english/
------------------------------------------------------------------
Dynamic websites for fast-moving businesses