On Jul 30, 11:49 pm, Brad Johnson <[EMAIL PROTECTED]>
wrote:
> Huang, Shun-Hsien <shuang <at> ercot.com> writes:
>
>
>
> but how do I copy a excel file into
>
> > database table by using Python?
>
> I'm not sure if this helps, but you can access the Excel Automation model very
> easily with:
>
> import win32com.client
>
> x1 = client.Dispatch("Excel.Application")
>
> Now you can use the x1 object to access any of the properties and methods in
> the
> Excel Automation model.
I have only used this to export data as Excel, but it may fulfill your
needs for importing:
http://sourceforge.net/projects/pyexcelerator/
Ali
--
http://mail.python.org/mailman/listinfo/python-list
