[thelist] Converting an Excel file

Veronica Yuill veronicay at archetype-it.com
Mon Feb 25 10:51:00 CST 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 at archetype-it.com
Archetype Information Technology Ltd  http://www.archetype-it.com/english/
------------------------------------------------------------------
Dynamic websites for fast-moving businesses




More information about the thelist mailing list