Excel, Python and Access

[JohnSeito]

Hi Guys,

I don't know if this is a good place to post this, but if is not, then I apologizes.

But I was wondering if anyone knows python codes well, an example code of how I can export access table into excel sheet using python ?
if this is not a good place to post this, I apologize in advance.

Thank you

 

[JohnSeito]

this is an excel forum and it involves Excel and I thought it would be a good idea since maybe someone has already done something similar to it.

The Access database and table are already created and located in a directory, just would like to use python code in a python file to export the access table into an excel sheet. Thanks !

 

[dmg2016]

I don't have python on my current computer, but I think you can accomplish it by using xlwings. Openpyxl may also be helpful in trying to do it.

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules. Be sure to follow & read the link at the end of the rule too.

Cross posted at: Access / Python Question

If you do cross-post in the future and also provide a link, then there shouldn’t be a problem.

 

[JohnSeito]

Ok peter_SSs thank you for letting me know, will do that and be more aware of it in the future.