import Excel csv - files

[Jürgen Kemeter]

Hi!

I have to import all data, stored in an
<http://www.tek-tips.com/viewthread.cfm?qid=1158204&page=1> Excel
workbook, into a PostgreSQL-database.

Herefore, I export Excel spreadsheets as .csv - files. 
My actual Python
<http://www.tek-tips.com/viewthread.cfm?qid=1158204&page=1> script
imports this csv-file, and generated PostgreSQL files (.psql), which
contain the  <http://www.tek-tips.com/viewthread.cfm?qid=1158204&page=1>
SQL statements for filling in the
<http://www.tek-tips.com/viewthread.cfm?qid=1158204&page=1> database
with the Excel data.

My actual Problem:
The Excel workbook contains several spreadsheets. These are linked
through Hyperlinks, and contain several cell comments.
How can I export these comments and Hyperlinks using Python? My aim is
to store these in a corresponding PostgreSQL table.

If it helps, I can send the Excel workbook, and an example .csv-file,
via email.

I enclosed the script for less email traffic.

cheers,
Juergen
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20051130/925bf5d6/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: importCSV.zip
Type: application/x-zip-compressed
Size: 3294 bytes
Desc: not available
URL: <http://mail.python.org/pipermail/python-list/attachments/20051130/925bf5d6/attachment.bin>