[Tutor] Excel to SQL DB using Python

[Alan Gauld]

On 25/02/2022 12:00, Hannah Jones wrote:
> Hello,
> 
> I need help with some code if possible please.
> 
> I am trying to convert an excel file to a list and then iterate over the list and add to an SQL database.

It's worth checking your database tools. Most have import facilities for
CSV files, even Sqlite can do very basic CSV imports(but not with
embedded commas etc) But Oracle, for example, can import all manner
of file formats.

-- 
Alan G
Author of the Learn to Program web site
http://www.alan-g.me.uk/
http://www.amazon.com/author/alan_gauld
Follow my photo-blog on Flickr at:
http://www.flickr.com/photos/alangauldphotos