nice video sir, really!! , but how we change the script on "for i in range(1,21)" if we want insert not specific row records (sometimes 21 row, 22 row, 45 row, etc..)
*Fantastic solution.* I have dates [2023-12-25] in one ROW and it return *DataError: 1292 (22007): Incorrect date value: '13733.0' for column 'nasc' at row 1*
it is helpful and proper explained but sir can you plz explain how we can pull the data from excel without knowing its row count ? like if we have thousands of record in excel that we don't know how many records are there how wecan add this to DB.
How to do the mapping if my excel file contains the the column of different tables.in such case what should be the approach to map in different tables of a same db simultaneously???
Hello Sir, This is a great tutorial! Would you please let me know, could the xlrd support openoffice writer? If it could, how to do? Thank you in advance!!!!
I have an excel sheet with lots of data spread randomly, i have created a normalized tabl, but how can I grab data thats spread randomly and insert it into sql db column. Anyone please help.. i tried ssis too but my data is very complicated excel forms.
All my love and best wishes for you. You are the best.
Literally how you explained its fabulous and so easy.
If any one get "Excel xlsx file; not supported" error . Follow this step
pip uninstall xlrd
pip install xlrd==1.2.0
Thanks
after doing this i am getting this error "AttributeError: 'ElementTree' object has no attribute 'getiterator'"
We are waiting for this concept sir
nice video sir, really!!
, but how we change the script on
"for i in range(1,21)"
if we want insert not specific row records (sometimes 21 row, 22 row, 45 row, etc..)
*Fantastic solution.*
I have dates [2023-12-25] in one ROW and it return *DataError: 1292 (22007): Incorrect date value: '13733.0' for column 'nasc' at row 1*
This was a great video! Thank you for doing these.
Waiting
it is helpful and proper explained but sir can you plz explain how we can pull the data from excel without knowing its row count ? like if we have thousands of record in excel that we don't know how many records are there how wecan add this to DB.
Very good session. Is that avoid duplication in SQL?
Sir , Please MAKE more videos on MS EXCEL
How to do the mapping if my excel file contains the the column of different tables.in such case what should be the approach to map in different tables of a same db simultaneously???
Sir I am getting programming error like not all parameters were used by the SQL statement.
Thankyou
*Sir how to import multiple excel sheet to the SQL using python???*
Hello Sir, This is a great tutorial! Would you please let me know, could the xlrd support openoffice writer? If it could, how to do? Thank you in advance!!!!
when using openpyxl what changes are to be made?
Getting error as Indentionerror: expected an indented block after For statemen.I tryied but unable to understand.Can u plz advise
thank you very much , but how to import excel file included arabic data?
I have an excel sheet with lots of data spread randomly, i have created a normalized tabl, but how can I grab data thats spread randomly and insert it into sql db column. Anyone please help.. i tried ssis too but my data is very complicated excel forms.
When I am opening Excel sheet it showing Excel class file ; not supported
Please confirm how to take date input from excel and put it on db. I'm getting error for this : Incorrect date value.
Format: yyyy-mm-dd
shows error
XLRDError: Excel xlsx file; not supported
I got the same error.
@@sambhavmishra5204 what you did then?
flashing error at executemany
xlrd is not opening xlsx format files please help
Can u pls send this code in Java plss
program error